Kbase P120274: Wrong results or "Transliteration failed" error when displaying an array column which contains exten
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  02/05/2007 |
|
Status: Verified
FACT(s) (Environment):
OpenEdge 10.1A
SYMPTOM(s):
"Transliteration failed" error when querying a table through the OpenEdge Architect
"Transliteration failed" error when displaying a column through JDBC
[DataDirect][OpenEdge JDBC Driver]Transliteration failed, reason: invalid UTF8 data
Wrong characters when displaying an array column through ODBC
The table contains an array column with extended characters
Wrong results when querying an array column which contains extended characters
The correct characters are displayed when displaying each element of the array column
CAUSE:
Bug# OE00134779
FIX:
Upgrade to 10.1B01 or later.
If upgrading is not an option, query the extents individually rather than as one field as a workaround.
For example:
SELECT ExtentField[1], ExtentField[2], ExtentField[3], ExtentField[4] from PUB.MyTable