Kbase P177334: Wrong datatype used when returning Unicode data from an iSeries database via IBM ODBC driver to MS A
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/11/2010 |
|
Status: Unverified
SYMPTOM(s):
Wrong datatype used when returning Unicode data from an iSeries database via IBM ODBC driver to Microsoft ADO called by Progress client
Unicode data is not returned / displayed correctly by Progress client
Progress client uses Microsoft ActiveX Data Objects (ADO) version 2.8 SP1 to establish connection to iSeries database via ODBC
Field in iSeries database has data type GRAPHIC CCSID 13488
GRAPHIC CCSID 13488 should translate to data type SQL_WCHAR (adWChar) according to ODBC 3.0 specification
Field is returned as data type SQL_CHAR (adChar)
iSeries ODBC driver version 11.00.12 is used for the connection
Same operation works correctly using OpenEdge 10.2x ODBC Wire Protocol Driver for DB2
FACT(s) (Environment):
OpenEdge 10.x
Windows
CAUSE:
The exact cause is unknown at the time of this writing but the issue would appear to relate to a bug in the iSeries driver
FIX:
Connect via IBM provider IBMDASQL and with local cursors (Servers cursors do not allow MoveFirst command).
The data type extracted for the column is adVarWChar which is another Unicode string type which therefore should return the correct data.