Kbase P163484: Error 11327 loading XML document into a LONGCHAR or CLOB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/04/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 11327 loading XML document into a LONGCHAR or CLOB
Error converting CLOB/LONGCHAR. (11327)
FACT(s) (Environment):
Using the OpenEdge 10 UTF-8 client.
COPY-LOB is being used to to load the XML into a LONGCHAR and another COPY-LOB to save the LONGCHAR to a CLOB field in the database.
The LONGCHAR and the database CLOB both use the UTF-8 code page.
The XML file doesn't have an encoding attribute in its XML processing Instruction header.
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The XML file contains extended characters and these characters are not encoded in UTF-8. Since the XML file does not contain an encoding attribute in its header, the parser assumes that the file content is written using the UTF-8 code page. If this is not the case then conversion errors will occur.
In this particular instance the XML file was encoded in UTF-16.
FIX:
Ask the provider of the XML file to either:
1. Include the correct encoding attribute in the XML header.
2. Encode the XML in UTF-8.