👨💻 Thank you for your blog visit! It's a good day. Bro. We will deal with the problem of "invalid byte sequence for encoding "UTF8" when using BCP commands in MSSQL. 🎯 Cause of error Encoding issues for a character ex) 0xba 🎯 Solution When writing the bcp command, enter the -C 65001 option. bcp "SELECT * FROM test" queryout "E:\test.csv" -S 192.168.0.1,1433 -U test -P 1234 -E -c -C 65001 If you..
[MSSQL, BCP] invalid byte sequence for encoding "UTF8"
👨💻 Thank you for your blog visit! It's a good day. Bro. We will deal with the problem of "invalid byte sequence for encoding "UTF8" when using BCP commands in MSSQL. 🎯 Cause of error Encoding issues for a character ex) 0xba 🎯 Solution When writing the bcp command, enter the -C 65001 option. bcp "SELECT * FROM test" queryout "E:\test.csv" -S 192.168.0.1,1433 -U test -P 1234 -E -c -C 65001 If you..
2023.06.08