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?

Answer 1

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