SQL Server 2000 database when sorting Latin1_GENERAL_BIN way, original concept 10.5 through OLE DB connection database, the data window display of Chinese is gibberish, the character set in the data window gb2312charset or by default, all garbled words, how to solve?

CodePudding user response:

Why not Latin1 can store text in the codes, database GBK

CodePudding user response:

Change the database character set


The oleDb used, but the database directly connected should be no problem

CodePudding user response:

Database is not changed, is already used, adding new features is now!
Only through other ways

CodePudding user response:

The Alter database [the database name] collate Chinese_PRC_CI_AS