This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
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!
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Hi, I must say that I am not very familar with centos 7, this issue may be more related to centos 7 itself. For less familar area, I suggest is to check the language settings of centos and whether support for Chinese text is already installed
Did you check the problem using other ways, such as exporting the row to a text file, then opening the file in a text editor that is able to display all of characters? Also try copying the file to Windows and viewing it. Make sure that the console and the fonts in Centos are able to show the characters.
Just a wild guess, but any of the characters that get rendered incorrectly be beyond the Unicode base plane, That is, U+10000 or greater?
Please bear with me. I don't know Chinese, so I am not able to say whether any of these characters are beyond the normal usage of Chinese.
If you post your question over several forums, then please link them to avoid have community more work the neccessary.
See my answer on
https://techcommunity.microsoft.com/t5/sql-server/sqlcmd-get-wrong-value-on-linux-centos-7/m-p/3271029