bcp out in UTF 8 format

Question

bcp out in UTF 8 format

rkjayaraj

Old Hand

Points: 343
More actions
June 21, 2008 at 7:38 am

#183694

I have SQL Server database table with International characters. Is there any way I can bcp out the table into csv file in UTF-8 format?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

AndreT78 Mr or Mrs. 500 Points: 574 More actions · Answer 1

rkjayaraj (6/21/2008)
I have SQL Server database table with International characters. Is there any way I can bcp out the table into csv file in UTF-8 format?

I have the same Problem, but my Destination is TXT.

declare @pfad varchar(8000)

set @pfad = 'bcp "select * from I_Kunden_EMail with (nolock)" queryout

"\\Server\export\Emailadressen\email'+convert(varchar(10),getdate(),112)+'.txt" -T -t; -w '

exec xp_cmdshell @pfad

Which Parameters I need für UTF-8

AndreT78 Mr or Mrs. 500 Points: 574 More actions · Answer 2

i get an answer in on an other board.

The Parameters are : -c -C65001

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.de.sqlserver&mid=69849d78-9d68-4cf4-89e6-1da5e3bf3d57

s-e-i-y-a Old Hand Points: 381 More actions · Answer 3

AndreT78 (6/23/2008)
i get an answer in on an other board.
The Parameters are : -c -C65001
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.de.sqlserver&mid=69849d78-9d68-4cf4-89e6-1da5e3bf3d57

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Micorsoft siaid "SQL Server does not support code page 65001 (UTF-8 encoding)."

No luck for me.

oliver 59000 Valued Member Points: 51 More actions · Answer 4

UTF-8 is not supported anymore for SQL Server 2008 (R2?), see http://msdn.microsoft.com/en-us/library/ms188365.aspx and go to CODEPAGE.

There's more info on the web as to why, but in short that's why it worked on SQL Server 2005 but not 2008 (R2).

AndreT78 Mr or Mrs. 500 Points: 574 More actions · Answer 5

AndreT78

Mr or Mrs. 500

Points: 574

March 30, 2011 at 12:02 am

#1305255

the thread is from 2008

Leoa SSC Journeyman Points: 95 More actions · Answer 6

It is good to learn about how to bcp out the table into csv file in UTF-8 format. Thanks for posting the link to the answer.

Leo

Website: How to Make Money Online Resources

shashi.bhusan123 SSC Journeyman Points: 79 More actions · Answer 7

Hey ,

Alter native of UTF8 support in SQLSERVER 2008 R2

1. if u are importing multiligual file keep this in UTF16(UCS2[LE]) format rather than UTF8 because BCP import dont support UTF8 code page in MS SQLSERVER R2.

2.table where u importing multiligual character, column should be NVARCHAR type

Follow BCP Command for import data

bcp [DATABASE].[dbo].[tablename] in TestBCP.txt(UTF16 format) -S<SERVER> -U<USRName> -P<PWD> -C -w

option -w support widecharacter(after 256)

plz let me know if helps

thanks

Shashi