s*****c
发帖数: 36 | 1 Hi, Jacky:
"Sort order" means how character data is compared and in
what sequence it is returned from a query. Both of 197 and
199 means "Dictionary order, case-insensitive", but the
former is only for "traditional Chinese" and the later is
for "simplified". Now it is clear that your target
database's default character set is "traditional Chinese".
It's the POINT! You can use "sp_configure " to learn the
configure of the two SQL Servers.
I copy this stuff from SQL Server's online help, but I
sug | j********g
发帖数: 58 | 2 Hi,Skeptic:
Thank you!!
......
【在 s*****c 的大作中提到】
: Hi, Jacky:
: "Sort order" means how character data is compared and in
: what sequence it is returned from a query. Both of 197 and
: 199 means "Dictionary order, case-insensitive", but the
: former is only for "traditional Chinese" and the later is
: for "simplified". Now it is clear that your target
: database's default character set is "traditional Chinese".
: It's the POINT! You can use "sp_configure " to learn the
: configure of the two SQL Servers.
: I copy this stuff from SQL Server's online help, but I
|
|
