I have a UTF8 data files as following
First line display the Title, will not import to database;|||||2|1|20080807 02:00|20080201 14:00:00|1.0000|第三行
3|1|20080807 13:00:00|20080201 00:00:00|1.0000|第三行
4|1|20080807 15:23:00|20080201 00:00:00|1.0000|第三行
9.061 SQLCHAR 0 10 "|" 1 numval Chinese_Hong_Kong_Stroke_90_CI_AS2 SQLCHAR 0 10 "|" 2 engval Chinese_Hong_Kong_Stroke_90_CI_AS3 SQLCHAR 0 24 "|" 3 datetimeval ""4 SQLCHAR 0 24 "|" 4 dateval ""5 SQLCHAR 0 41 "|" 5 decval ""6 SQLNCHAR 0 200 "\r\n" 6 chival Chinese_Hong_Kong_Stroke_90_CI_AS
I try to use format file import to Sql Server by the chinese character become unknow character. Is there have anyway I can import correct chinese character into Sql Server by using format file.
Also, why bcp does not recognize first line if I do not add enough of "|" symbols at the end of first line.
Not sure about this one - I recommend you post this over in the SSIS forums. They have more experience with the multi-language imports.
Thanks for participating the forums!
Program Manager, Microsoft SQL Server
Learn more about SQL Server for Free: http://www.microsoft.com/sql/editions/express/learnvideos.mspx
Great Podcast for SQL Server: http://edge.technet.com/Tags/Database+Administration/feed/ipod/
More about me: http://buckwoody.com
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?