How do I BCP Unicode text into a table by using Format file?
I will be receiving a big text file daily, with some Chinese characters. I need to load into SQL server. How do I create the format file? I have tried following format file, but it does not work. 8.0 2 1 SQLNVARCHAR 0 100 "\t\0" 1 Col1 SQL_Latin1_General_CP1_CI_AS 2 SQLNVARCHAR 0 100 "\r\0\n\0" 2 Col2 SQL_Latin1_General_CP1_CI_AS Thank you in advance.