Transfer data from BIG5 to Unicode? -
10-19-2004
, 01:05 AM
Should any processes be done before transfer the data from BIG5 to Unicode
using DTS? I try to transfer the data directly from table to table (both are
SQL Server 2000), but finally, I can't read the chinese character in the
destination table. In the destination SQL server, the collation is
Chinese_Taiwan_Stroke_CI_AS. The source datatype is used varchar to store
the BIG5 chinese character, but the destination datatype is used nvarchar or
ntext to store the Unicode chinese character. |