Code - Unicode - UTF8 - All encoding woes.

[Nagesh]

bcp dbo.Comments out "c:\temp\ALLcomment.csv" -S "mylocalserver" -d "mylocaldb" -T -N

This is the output!

D U n i c o d e d o e s n o t o u t p u t c o r r e c t l y ! 

I am not liking this mess!

[Unperverted Vixen]

Looks like it's being written as UTF-16, not UTF-8.

[Magus]

@Unperverted-Vixen Which, for the sake of additional information, is normal for Microsoft products to do.

[pie_flavor]

@Magus Along with the extra BOM.