October 30, 2007 at 8:46 am
I am pulling data from China using 2 different methods. In one case, a text file is sent to an FTP site and a .dts package accesses it and pulls the data into tables on the SQL server. In the other instance, I am connecting to a SQL server 2000 box in China and pulling data via SSIS. In the first case, the Chinese characters are readable in the FTP file but if I query the table on my box and dump it into EXCEL, they are not. I do not know if the problem is the underlying data or the interface.
Any help/ideas would be greatly appreciated!
October 31, 2007 at 12:25 pm
Run a search for Chinese collation sort in the BOL. Sounds like the collation in the database could be presenting a problem. Hope this helps 🙂
196 Chinese_Taiwan_Stroke_BIN
197 Chinese_Taiwan_Stroke_CI_AS
198 Chinese_PRC_BIN
199 Chinese_PRC_CI_AS
200 Japanese_CS_AS
201 Korean_Wansung_CS_AS
202 Chinese_Taiwan_Stroke_CS_AS
203 Chinese_PRC_CS_AS
Tommy
Follow @sqlscribeOctober 31, 2007 at 2:02 pm
Thanks! I'll chekc it out.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply