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!
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)业务逻辑层。负责主要的业务流程服务、界面定义服务、媒体服务、文件服务、推送服务、数据报?矸瘛⑷罩痉瘛⑾低嘲踩瘛⒉檠芾矸瘛⑸矸菁ǚ瘛⒆橹撕殴芾矸瘛9芾砗筇