ms sql server 2000 中文版 --〉英文版的问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

ms sql server 2000 中文版 --〉英文版的问题

ms sql server 2000 中文版 --〉英文版的问题# Database - 数据库

d*r2002-06-27 07:06

1 楼

need to create a new database on a machine that has ms sql server 2000 chinese
version, but later the database will be moved to a machine with english
version, eg. using detach/attach.
if all the data are in english, would there be any problem?
never used the chinese version b4, thanks !

p*s2002-06-27 07:06

2 楼

As long as you define the character using the right character sets, it should
be no problem.
Even you define the character sets as GB2312, as long as the english version
also had that character sets installed, and choose that as default character
sets, the moving will not be a problem either.
DTS, Data Transformation Service, will do that for you.
However, never done that before, just my thought. It would be save to define
the character sets as English sets and try to avoid using the NCHAR.

【在 d*******r 的大作中提到】

: need to create a new database on a machine that has ms sql server 2000 chinese
: version, but later the database will be moved to a machine with english
: version, eg. using detach/attach.
: if all the data are in english, would there be any problem?
: never used the chinese version b4, thanks !