Consultor Eletrônico



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