Redian新闻
>
Re: SQL Server restore(transferred from other DB) error... HELP!
avatar
Re: SQL Server restore(transferred from other DB) error... HELP!# Database - 数据库
s*c
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
avatar
j*g
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

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。