I need dump table from SQL Server to csv in utf-8

Question

This works but not in utf-8:

sqlcmd -S Server -d DB -E -s, -W -i "C:\Localdata\test.sql" | findstr /V /C:"-" /B > "C:\Localdata\Test.csv"

Would anybody like to help fix this into utf-8?

score 12 · Answer 1 · edited Aug 12 '20 at 13:06

12

add -f 65001 to the sqlcmd command. (or -f o:65001 if you want UTF-8 output, -f i:65001 for UTF-8 input)

edited Aug 12 '20 at 13:06

Bill Tür stands with Ukraine

3,425
30
38
48

answered Aug 12 '20 at 12:49

denbrice

121
1
2

score 6 · Accepted Answer · answered Jan 10 '17 at 05:27

6

You can use the -u switch for Unicode format output file.

Docs

answered Jan 10 '17 at 05:27

shree.pat18

21,449
3
43
63

score 2 · Answer 3 · answered Aug 06 '20 at 20:22

2

type chcp 65001 in the command line or batch file before calling sqlcmd

answered Aug 06 '20 at 20:22

robotik

1,837
1
20
26

score 0 · Answer 4 · answered Jul 31 '20 at 12:23

But it's not UTF-8.

sqlcmd automatically recognizes both big-endian and little-endian Unicode input files. If the -u option has been specified, the output will always be little-endian Unicode.

And thus, for instance, it disables using diff tool to compare output.

To overcome this M$ "comfort" with tool - use iconv:

iconv -t UTF-8 <sqlcmd.output.csv>

At Windows as "comfortable" М$ product again - you can use iconv from Git command line tool bundle, for instance.

I need dump table from SQL Server to csv in utf-8

4 Answers4