I had problems similar to this a few years back. I had to check the CCSID of the modules in the RPG program (DSPPGM), the CCSID of the database files (DSPFD) and *also* the CCSID of the fields in the files (DSPFFD). Don't forget to check the FD and FFD of the RPG source files. All could be overridden during creation or picked up the wrong default at creation time. In my case it turned out that a field on a database file was overridden (in the DDS source) to the wrong CCSID, but that isn't likely in most cases.

You can also specify CCSID on stored procedure parameters (and SQL fields) so if you are using those then that might be another area to check.


-Paul.


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: 11 December 2012 15:20
To: Java Programming on and around the IBM i; rpg400-l@xxxxxxxxxxxx
Subject: RE: RPG, Java and national characters

What'd the CCSID of your RPG source file?

There's a lot of mysteries surrounding character translation for me when it comes to RPG/Java interface so this is pure speculation. However, I know that constants in your RPG source are handled in the CCSID of the source file. Those constants are, of course, embedded in the compiled code. I *think* those constants are translated into unicode at run time (when the java method is called) based on the source CCSID.

The question mark means its an untranslatable character. In other words, there's no entry in the translation table at that code point.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Szymon Nawrocki
Sent: Tuesday, December 11, 2012 2:19 AM
To: rpg400-l@xxxxxxxxxxxx; java400-l@xxxxxxxxxxxx
Subject: RPG, Java and national characters

Hi

I'a trying to use RPGMail (Arron's Bartell tool), to expand my RPG and Java

skills - and everything is fine except one problem with national

characters.

When I try to send e-mails with Polish specific characters ("ąęźńł") -

for example in a subject - recipent always gets question mark '?' sign

instead one of that strange polish ones. I've checked everything I suspect

that could be a problem and now I run out of ideas ...



- JVM is running with polish encoding (ISO8859-2)

- iSeries CCSID is Polish

Polish characters hardcoded in Java sources are sent OK, when I code them

in RPG sources (get from database) they go wrong ..



Maybe someone could give me some advise or prompt what to check ...

Regards

Szymon

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.



--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.


Scanned by MailDefender - managed email security from intY - www.maildefender.net

Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.

We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.

Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF is authorised and regulated by the Financial Services Authority.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.