Unconvertible character

Posted by steasdale on 14-Nov-2017 03:14

I am getting the following error with the following command:

COPY-LOB FROM ipXMLFileData TO GridSetting.XMLFileData.

Unconvertible character found in source data with codepage UTF-8 to codepage ISO8859-1 (12009).
Could not update large object segment during copy.

ipXMLFileData is a LONGCHAR.

GridSetting.XMLFileData is a temp table field:  FIELD XMLFileData AS CLOB COLUMN-CODEPAGE "UTF-8":U

The ipXMLFileData variable is being set to an Ultragrid column settings xml.

How can I fix the 'unconvertible character' error please?

All Replies

Posted by Garry Hall on 14-Nov-2017 09:05

I believe this message is telling you the source data contains characters that are not in the codepage of the target. If you are consuming UTF-8 data, your client's -cpinternal should be able to handle all characters you expect to receive from the UTF-8 data. Try with -cpinternal UTF-8.

Posted by steasdale on 14-Nov-2017 10:48

Hello Garry,

I have applied FIX-CODEPAGE statements in several locations, plus ensuring the use of COPY-LOB is working with consistent codepage settings.

I also had to apply code changes in the location where I use the UltraGrid:DisplayLayout:SaveAsXML command to build the xml (from the Ultragrid settings) so that I output to an xml file, then use a COPY-LOB back to the LONGCHAR. My previous code was using SaveAsXML with a System.IO.MemoryStream(), which appeared to be contributing to the character 'not in codepage' issue.

As a result, this has fixed the issue.



This thread is closed