FAILED: Fetch statement failed: Encoding or code set not supported. error -79783

Technote (troubleshooting)


Problem(Abstract)

After JDBC upgrade to 3.50.JC1 onwards, customer who are using Multibyte codeset might received error such as : "FAILED: Fetch statement failed: Encoding or code set not supported. " error -79783

Symptom

Error message: "FAILED: Fetch statement failed: Encoding or code set not supported. "

error -79783

Cause

JDBC version 3.50.JC1 introduced the following APAR:

IC49877 -
JDBC DRIVER ALLOWS INSERTION OF INVALID CHARACTERS FOR CHARACTER SET.
http://www-01.ibm.com/support/docview.wss?uid=swg1IC49877

While the behavior for this APAR is correct, it might lead to problems for those customers who use Native Multibyte data on the application side but store them into en_us locale on the server side.

In some case, for customer who are using zh_tw.big5 locale on the server side; but stored illegal characters in the table will also be effected.


Diagnosing the problem

Error message happened right after upgrade.

Resolving the problem

Since version JDBC 3.50.JC5, user can set a flag IFX_USE_STRENC to switch to old style of encoding.


Here's an example on how to use it:
"jdbc:informix-sqli://inst:port:dbname:informixserver=XXX;user=informix;password=XX;DB_LOCALE=en_us.819;IFX_USE_STRENC=true;"


Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Tools
Informix JDBC

Software version:

3.5

Operating system(s):

AIX, DYNIX/ptx, Digital Unix (OSF1)(TRU64), HP-UX, IRIX, Linux, Mac OS X, Reliant UNIX, Sinix, Solaris, Windows

Software edition:

Compiler, Developer, Rapid Development System

Reference #:

1502902

Modified date:

2013-06-18

Translate my page

Machine Translation

Content navigation