Transfer data from BIG5 to Unicode?
From: epjames (epjames_at_discussions.microsoft.com)
Date: 10/19/04
- Next message: Jens Weiermann: "Re: DDQ help needed: If row exists then update else insert..."
- Previous message: Sue Hoegemeier: "Re: Problem with nightly runs"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 18 Oct 2004 23:05:03 -0700
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.
- Next message: Jens Weiermann: "Re: DDQ help needed: If row exists then update else insert..."
- Previous message: Sue Hoegemeier: "Re: Problem with nightly runs"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
