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 |
|
snpradhan
Starting Member
1 Post |
 Posted - 2013-10-01 : 09:54:29
|
| I need to do BCP export with special characters (é,õ etc.). Currently I am using bcp ...queryout... -T -w which gives the text file in Unicode with the special characters. However now I need to send the BCP in UTF-8 format now. I tried using UTF-8 codepage -C 65001, didn't work. Can anyone help? Thanks! |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2013-10-01 : 10:45:49
|
| BCP support for UTF-8 was removed a couple of versions ago - don't ask me why.You will probably have to use SSIS (unless it's changed since the last time I needed it).==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
BCP export in UTF-8