SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 BCP export in UTF-8
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

snpradhan
Starting Member

1 Posts

Posted - 10/01/2013 :  09:54:29  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 10/01/2013 :  10:45:49  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000