Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to handle 'graphic' fields
17 views
Skip to first unread message
tomasz
Jan 9, 2012, 4:38:50 PM1/9/12
to
Hi.
I'm trying to query DB2 table on iSeries,
DSPFFD for most of fields shows values:
---
PSTLZ GRAPHIC 10 20 265 Both PSTLZ
Default value . . . . . . . . . . . . . . :
UX'0020'
Coded Character Set Identifier . . . . . : 13488
UCS2 or Unicode conversion . . . . . . . : *CONVERT
---
Table has multilangual data (Polish, Czech, German itp.).
All I need is to run from linux PHP script (ODBC driver from iSeries
Access for linux) and get valid Polish characters.
I have an experience with tables with CCSID 870 and 37 and it always
works fine. But in that case all I get is a mess.
Does anybody can give me any tips, I'm working on it for last few days
without any result.
Do I need any specific odbc.ini settings?
Regards.
Tomasz
I'm trying to query DB2 table on iSeries,
DSPFFD for most of fields shows values:
---
PSTLZ GRAPHIC 10 20 265 Both PSTLZ
Default value . . . . . . . . . . . . . . :
UX'0020'
Coded Character Set Identifier . . . . . : 13488
UCS2 or Unicode conversion . . . . . . . : *CONVERT
---
Table has multilangual data (Polish, Czech, German itp.).
All I need is to run from linux PHP script (ODBC driver from iSeries
Access for linux) and get valid Polish characters.
I have an experience with tables with CCSID 870 and 37 and it always
works fine. But in that case all I get is a mess.
Does anybody can give me any tips, I'm working on it for last few days
without any result.
Do I need any specific odbc.ini settings?
Regards.
Tomasz
iseriesflorida
Jan 10, 2012, 9:46:22 AM1/10/12
to
What if you change your odbc setups CCSID or the job doing the ODBC's
ccsid.
ccsid.
0 new messages