Hi,
Table on iSeries has CCSID 13488 (I used DSPFD command to check),
system values on OS are:
QCCSID -
Coded character set
identifier . . . . . : 65535

QCHRID -
Character ID . . . . . : 697
Code page . . . . . . : 37

All I need is to query that table from Linux with iSeries Access
installed.
In odbc.ini datasource I uss looks like this:
[SAP_TST]
Driver = iSeries Access ODBC Driver
System = XXX.XXX.XXX.XXX
DefaultLibraries = R3PRDDATA
AllowUnsupportedChar = 1
CCSID = 1250

Problem is that when I run my simple php script that only make sql
select from that table I don't get any Polish characters. When tables
CCSID is 870 everything works fine.

What shall I do?

Regads,
Tomasz

tom <t.stefaniak (AT) gmail (DOT) com> wrote in news:3844a146-645d-4903-a1d7-
a116a6337ef8 (AT) e2g2000vbb (DOT) googlegroups.com:

Hi Tomasz,

Although I do have experience with character code conversions on zOS, I
don't have any experience with iSeries, nor with accessing DB2 via PHP
(let alone in Polish...).
Here's a nice presentation, however, that might help you:

http://www.alanseiden.com/presentati...-and-PHP-best-
practices-on-IBM-i.pdf

[Have a look at slides 65-68]

If you still need help, you might be better of asking on this forum:

http://forums.zend.com/

[The 3rd forum on that page is specific for PHP on IBMi]

HTH.

Cheers!

--
Jeroen