INSERT into table with CCSID 65535

General discussion on Zend Server for IBM System i
Post Reply
gfroehlich
Posts: 24
Joined: Tue Jul 06, 2010 11:48 am

INSERT into table with CCSID 65535

Post by gfroehlich » Thu Jan 31, 2019 12:38 pm

Hello,

I'm in the ugly situation that I have write into a table from an old ERP system that uses CCSID 65535. To change the CCSID to a better value like 37 is not an option, because I'm simply not allowed to do that on the productive system.

For reading data I found a solution with casting each character field to a proper CCSID, but I found no workaround for inserting & updating data.

Is there a driver option available to force translation for CCSID 65535 e.g. i5_force_translate like it is available for ODBC and OLEDB "Force Translate=1;"?

All hints from the net I found are already there.
fastcgi.conf:
...SetEnv="CCSID=819" SetEnv="LANG=C" ...

httpd.conf:
...
DefaultFsCCSID 37
CGIJobCCSID 37
...


ZS: IBM i 6.2.0
PHP: 5.4.21
OS: IBM i V7R1
WS: Apache 2.0 5770DG1
pdo_ibm: 1.3.3

best regards
Gabriel

Post Reply