English SQLSERVER2000 does not support Chinese?

Category: MS-SQL Server -> Others Author: woshiyingjie Date: 2004-08-12 13:05:33
 
woshiyingjie
2004-08-12 13:05:33
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! ! !
someany2
2004-08-12 13:17:12
the library's default sort mode to chinese_rpc_ci_as

change the database character set encoding can be used:

ALTER DATABASE database
COLLATE ....
xiaoxia1071
2004-08-12 13:24:41
1. was changed database COLLATATION
2. changing field data type
flornabobo
2004-08-12 13:27:32
msdn_lib: Brother Can a little more careful
xubo1234567998
2004-08-12 13:43:57
your field with what type
ggmimi088
2004-08-12 14:03:10
using a CHAR, a length of 100 or 10, I typed a character on an error: Mismatched type or length.
I use alter database test collatation ...., then Tip: 1, can not lock the database. 2, CONNECTION errors.
I also use USER TEST
GO
ALTER ...
GO
still prompts the same error.
save me!
live_xz
2004-08-12 14:19:56
Correction: collatation ---> collate