CODEWITHSUNDEEP
pythonsql-serverpython-3.xsqlcmdsqlcommand
user13921072
user13921072

Reputation:

SQL Server : using command prompt doesn't display the Chinese character but SSMS does

I have a table with INSERT INTO ABC("1000", "短消息"), I am able to execute it with SSMS but not with sqlcmd as it is accepting it and the output is [1000, J'aime] but not the Chinese character.

I am passing .sql file in cmd as

myCommand = 'sqlcmd  -i %s -o %s' , input , outputfile

I tried putting .encode('UTF-8') option but it shows the same result and my file is already in UTF-8 format as per notepad++

Upvotes: 1

Views: 143

Answers (0)

Related Questions