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 ♦♦
1.2k6384105
accept rate: 76%


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

link

answered 22.11.2016 at 14:34

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
7.4k11347
accept rate: 71%

edited 07.03 at 10:29

Alex%20Suter's gravatar image

Alex Suter ♦♦
1.8k61935

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

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

Tags:

×5
×4

Asked: 22.11.2016 at 14:31

Seen: 732 times

Last updated: 07.03 at 10:29