With a NChar field containing characters that are not supported in current ANSI/OEM code page.

Update TableName Set NonUniField=UniField;

Raises "Error 5211: There is an error converting Unicode string to or from code page string. Some Unicode characters cannot be converted to code page characters."

Is there any way (in SQL) to assign only the current code paged supported values to the Char field?


asked 28 Jan '14, 14:45

Jack's gravatar image

accept rate: 14%

edited 26 Feb '15, 09:25

Jens%20M%C3%BChlenhoff's gravatar image

Jens Mühlenhoff

No, there is no way to do that with current implementation. The low level conversion function supports replacing nonconvertible characters with a default ANSI code page character but that functionality is not exposed.


answered 28 Jan '14, 16:41

Alex%20Wong's gravatar image

Alex Wong
accept rate: 42%

edited 28 Jan '14, 16:43

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
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: 28 Jan '14, 14:45

Seen: 2,188 times

Last updated: 26 Feb '15, 09:25

Advantage Developer Zone Contact Us Privacy Policy Copyright Info

Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.