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.
midrange.com
