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 |
|
B0g
Starting Member
19 Posts |
 Posted - 2008-03-07 : 05:37:07
|
| Hello there,I need to export some records from SQL Server 2005 to a file with different types of encoding: ASCII, UTF-8, UTF-16, UTF-16BE, UTF-16LE.For export I use bcp utility, but I can't find a way to encode that file to UTF-8, UTF-16, UTF-16BE, UTF-16LE. I tried -C option and also the format file with collations for the char fields.Does any of you have an ideea about that?10x,B0g |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-07 : 23:13:21
|
| I believe you need encoding tool for that. |
 |
|
|
|
|
|
bcp out to a UTF-8 encoded file