BCP Command Import in Non English language

Question

Hi, I am using BCP to Import data from utf-8 text file. Here my concern is , for Russian data BCP command works fine in Machine language with English regional setting. But same command, not works ones Machine Language changed to Russian.

Below is my command, [xTemp_Table] IN "C:\data.txt" -w -F1 -k -tþ|þ -T -S test01\test01 In Russian language it gives error as below, SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in BCP data-file Where same command executes fine in English machine language. Do i need to install any other ODBC or BCP setting ? Here i am usig BCP version 13.

Thanks

Answer 1

from utf-8 text file.

Which SQL Server/BCP version are you using? Older versions don't support UTF-8, see bcp Utility : "Versions prior to version 13 (SQL Server 2016 (13.x)) do not support code page 65001 (UTF-8 encoding)"