https://answers.axonivy.com/questions/2210/how-to-store-mandarin-chinese-text-into-a-mssql-database<p>I'm trying to insert UTF-8 encoded strings with mandarin language (e.g. 文化大學華 hey) into a MsSql table. The Collation is Latin1_General_CI_AS. </p> <p>But the special characters are always stored with question mark characters (e.g. ????? hey). How can I store the values so that they can be read afterwards?</p>enTue, 22 Nov 2016 14:34:18 -0500https://answers.axonivy.com/questions/2210/how-to-store-mandarin-chinese-text-into-a-mssql-database/2211<p>You can write the values with an 'N' prefix as described here: <a href="http://stackoverflow.com/questions/21726478/utf-8-character-gets-changed-in-insert-statement-on-ms-sql-server">http://stackoverflow.com/questions/21726478/utf-8-character-gets-changed-in-insert-statement-on-ms-sql-server</a></p> <p>The add the prefix the Db query type must be changed from 'write query' to 'any other query'.</p> <p><img alt="alt text" src="http://answers.axonivy.com/upfiles/prefixValueWithN.PNG"> <img alt="alt text" src="http://answers.axonivy.com/upfiles/columnColation.PNG"> <img alt="alt text" src="http://answers.axonivy.com/upfiles/mandarinInMsSql.PNG"></p> <p>See the sample project for an implementation example: <a href="/upfiles/utf8PagesMsSqlStore_51.iar">utf8PagesMsSqlStore_51.iar</a></p>Reguel WermelingerTue, 22 Nov 2016 14:34:18 -0500https://answers.axonivy.com/questions/2210/how-to-store-mandarin-chinese-text-into-a-mssql-database/2211