You can write the values with an 'N' prefix as described here: http://stackoverflow.com/questions/21726478/utf-8-character-gets-changed-in-insert-statement-on-ms-sql-server The add the prefix the Db query type must be changed from 'write query' to 'any other query'. ![alt text][1] ![alt text][2] ![alt text][3] See the sample project for an implementation example: [utf8PagesMsSqlStore_51.iar][4] [1]: http://answers.axonivy.com/upfiles/prefixValueWithN.PNG [2]: http://answers.axonivy.com/upfiles/columnColation.PNG [3]: http://answers.axonivy.com/upfiles/mandarinInMsSql.PNG [4]: http://developer.axonivy.com/q-and-a-attachments/utf8PagesMsSqlStore_51.iar/upfiles/utf8PagesMsSqlStore_51.iar

You can write the values with an 'N' prefix as described here: http://stackoverflow.com/questions/21726478/utf-8-character-gets-changed-in-insert-statement-on-ms-sql-server The add the prefix the Db query type must be changed from 'write query' to 'any other query'. ![alt text][1] ![alt text][2] ![alt text][3] See the sample project for an implementation example: [utf8PagesMsSqlStore_51.iar][4] [1]: http://answers.axonivy.com/upfiles/prefixValueWithN.PNG [2]: http://answers.axonivy.com/upfiles/columnColation.PNG [3]: http://answers.axonivy.com/upfiles/mandarinInMsSql.PNG [4]: http://www.ivyteam.ch/downloads/q-and-a-attachments/utf8PagesMsSqlStore_51.iarhttp://developer.axonivy.com/q-and-a-attachments/utf8PagesMsSqlStore_51.iar

You can write the values with an 'N' prefix as described here: http://stackoverflow.com/questions/21726478/utf-8-character-gets-changed-in-insert-statement-on-ms-sql-server The add the prefix the Db query type must be changed from 'write query' to 'any other query'. ![alt text][1] ![alt text][2] ![alt text][3] See the sample project for an implementation example: http://www.ivyteam.ch/downloads/q-and-a-attachments/utf8PagesMsSqlStore_51.iar[utf8PagesMsSqlStore_51.iar][4] [1]: http://answers.axonivy.com/upfiles/prefixValueWithN.PNG [2]: http://answers.axonivy.com/upfiles/columnColation.PNG [3]: http://answers.axonivy.com/upfiles/mandarinInMsSql.PNGhttp://answers.axonivy.com/upfiles/mandarinInMsSql.PNG [4]: http://www.ivyteam.ch/downloads/q-and-a-attachments/utf8PagesMsSqlStore_51.iar

You can write the values with an 'N' prefix as described here: http://stackoverflow.com/questions/21726478/utf-8-character-gets-changed-in-insert-statement-on-ms-sql-server The add the prefix the Db query type must be changed from 'write query' to 'any other query'. ![alt text][1] ![alt text][2] ![alt text][3] See the sample project for an implementation example: http://www.ivyteam.ch/downloads/q-and-a-attachments/utf8PagesMsSqlStore_51.iar [1]: http://answers.axonivy.com/upfiles/prefixValueWithN.PNG [2]: http://answers.axonivy.com/upfiles/columnColation.PNG [3]: http://answers.axonivy.com/upfiles/mandarinInMsSql.PNG

You can write the values with an 'N' prefix as described here: http://stackoverflow.com/questions/21726478/utf-8-character-gets-changed-in-insert-statement-on-ms-sql-server The add the prefix the Db query type must be changed from 'write query' to 'any other query'. ![alt text][1] ![alt text][2] ![alt text][3] [1]: http://answers.axonivy.com/upfiles/prefixValueWithN.PNG [2]: http://answers.axonivy.com/upfiles/columnColation.PNG [3]: http://answers.axonivy.com/upfiles/mandarinInMsSql.PNG