scottklement.com

ciao Scott
I'm back again....

I have the same problem of chinese chars in WRITING out an excel spreadsheet...

I have a file in AS400 with the correct chinese chars.. I can see them in a subfile or sql select

But when I create the xlsx they become strange chars... not for sure chinese chars!

Do ...

Thank you Scott
we are not far from the right result!

Now I got some chinese char but it seems that there is a sort of "translation" between standard chinese char and traditional chinese char.
At this point maybe is the excel file which has been created with a different chinese char set ...

Thank you Scott

I also changed the CCSID of the job to
Coded character set identifier . . . . . . . . . : 937
Default coded character set identifier . . . . . : 937
but it does not work
I still get the ?

In you opinion it is not related the way Java reads the data but to the different ...

here:

D String_getBytes...
D pr 1024A varying
D extproc(*JAVA:
D 'java.lang.String':
D 'getBytes')



cell = SSRow_GetCell(row: 9);
projdescr = String_getBytes(SSCell_getStringCellValue(cell));

from the PF definition:
A PROJDESCR 60O CCSID(937)


from the job:
Language identifier ...

Hi Scott
I have to import an excel spreadsheet with some chinese text

I have an Iseries with a chinese partition (double byte) where I normally handle chinese characters

for the first time I should import in my DB an excel with some chinese text.

The latin characters are ok, but the chinese text ...