Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swanandmokashi
Starting Member
1 Post |
 Posted - 2010-03-07 : 15:04:28
|
| HelloI have a C# application that imported csv, tab delimited, text files etc to SQL server 2008. i am using SqlBulkCopy class to do the import and create a .ini schema file to add the delimiters character sets etcThe application worked great so far, however now we need to import a UTF-8 Unicode tab delimited file, which has some german characters in there that need to be retained. THis is where the problem is. If I use the character set as ANSI, it imports fine however loses the german characters and replaces it with junk. If I use the character set as UNICODE, it is not able to understand the tab as the column delimiter and hence gives an error trying to match the source and destination columnsI can provide the sample text file as well as the schema file generated, but I do not see a way to attach files to the forum thread herePlease help!Thanks in advance |
|
|
|
|
|
SqlBulkCopy issue with Unicode files