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.

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?

asked 22.11.2016 at 14:31

SupportIvyTeam's gravatar image

SupportIvyTeam ♦♦
accept rate: 77%

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 alt text alt text

See the sample project for an implementation example: utf8PagesMsSqlStore_51.iar


answered 22.11.2016 at 14:34

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
accept rate: 70%

edited 07.03.2018 at 10:29

Alex%20Suter's gravatar image

Alex Suter ♦♦

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 22.11.2016 at 14:31

Seen: 2,223 times

Last updated: 07.03.2018 at 10:29