症狀:兩台sql server 2000,一台的collation name:SQL_Latin1_General_CP1_CI_AS
另一台:Collation name:Chinese_Taiwan_Stroke_CI_AS
當把資料從Collation name為Chinese_Taiwan_Stroke_CI_AS的那台server轉到另一台server時出現亂碼,請問該怎麼解決呢???
---------------------------------------------------------------
用unicode字符类型
char\varchar\text都改成nchar\nvarchar\ntext