English SQLSERVER2000 does not support Chinese?

Category: MS-SQL Server -> Applications Author: FCBLOVE Date: 2011-06-30 09:22:27
2011-06-30 09:22:27
English SQLSERVER2000 restore Chinese version of the table structure and data, Chinese is displayed as? ; Enter the Chinese, suggesting that type or length mismatch. However, there is no error checking, how to do? Expert help me! ! !
2011-06-30 09:35:33
English SQLSERVER2000 installation, choose the default collation for Simplified Chinese. Once installed database, Master table proofreading can not change it back, unless Rebuild master table. If so, it might as well re-install the Database. Reuse the original script to generate the table structure, and then import all the data.
can use this statement to look at your proofreading:
SELECT * FROM :: fn_helpcollations ()
such a statement can be used to modify your database: (assuming you The database is a test)
alter database test collate Chinese_PRC_BIN

Misrosoft recommendations are as follows:
Altering the default collation of a database does not change the collations of the columns in any existing user-defined tables. These can be changed with ALTER TABLE. The COLLATE CLAUSE on an ALTER DATABASE statement changes:

The default collation for the database. This new default collation is applied to all columns, user-defined data types, variables, and parameters subsequently created in the database. It is also used when resolving the object identifiers specified in SQL statements against the objects defined in the database.

Any char, varchar, text, nchar, nvarchar, or ntext columns in system tables to the new collation.

All existing char, varchar, text, nchar, nvarchar, or ntext parameters and scalar return values ​​for stored procedures and user-defined functions to the new collation.

The char, varchar, text, nchar, nvarchar, or ntext system data types, and all user- defined data types based on these system data types, to the new default collation.
After a collation has been assigned to any object other than a column or database, you cannot change the collation except by dropping and re-creating the object. This can be a complex operation. To change the default collation for an instance of Microsoft ® SQL Server ™ 2000 you must: ;

Make sure you have all of the information or scripts needed to re-create your user databases and all of the ; objects in them.

Export all of your data using a tool such as bulk copy.
Drop all of the ; user databases.
Rebuild the master database specifying the new collation.
Create all of the databases and all of the objects in ; them.
Import all of your data.

Note: Instead of changing the default collation of an instance of SQL Server 2000, you can specify a default collation for each new database you create.

2011-06-30 09:46:37
kipling: thanks ,
I use alter database test collate chinese_prc_bin
but an error
Server: Msg 5030, Level 16, State 2, Line ; 1
The database could not be exclusively locked to perform the operation.
Server: Msg 5072, Level 16, State 1, Line 1
ALTER DATABASE failed. The default collation of database 'test' cannot be set to Chinese_PRC_BIN.