Forum Discussion
sqlcmd get wrong value on linux(centos 7)
try to get a big text from server,
same datasouce(sqlsever 2014),
same sql (Select sTXTContent from NEMR_Doc where iid = 7693389),
but get wrong value on linux, how to fix?
part of the return value were wrong coded, see the screenshot.
I have tried chenge ODBC Driver for SQL Server 17 to ODBC Driver for SQL Server 18，but it had no effec.
This problem has bothered me for several days,thank you for your answer!
2 Replies
but get wrong value on linux, how to fix?model3 , what do you mean with "wrong value" here?
Your screenshots are that little, I can not see anything. And the language is one I don't can read/understand.
Additional note: CentOS isn't supported, see Overview of SQL Server on Linux - SQL Server | Microsoft Docs
olafhelper thank you.
text language is chinese.
sql server 2014 installed on windows server. sqlcmd runs on linux get "wrong value".
"wrong value" :a few character of text were incorrect encoded ,though most of text were correct encoded.
correct encode like this:
（3）业务逻辑层。负责主要的业务流程服务、界面定义服务、媒体服务、文件服务、推送服务、数据报表服务、日志服务、系统安全服务、查询管理服务、身份鉴权服务、组织账号管理服务
incorrect encode like this
（3）业务逻辑层。负责主要的业务流程服务、界面定义服务、媒体服务、文件服务、推送服务、数据报?矸瘛⑷罩痉瘛⑾低嘲踩瘛⒉檠芾矸瘛⑸矸菁ǚ瘛⒆橹撕殴芾矸瘛９芾砗筇
The red text is incorrect
