Bruce,
My example had the database fields defined as CCSID 1200 and the DSPF fields defined as 13488. This works in iSeries Access for Web at V5R4. Defining the DSPF fields as 1200 did not work.
Regards,
Sean
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bruce Vining
Sent: 27 February 2009 10:43
To: RPG programming on the IBM i / System i
Subject: Re: iSeries Access for Windows and unicode
For your database use UCS-2 (CCSID 13488).
You would think that UTF-16 (CCSID 1200) would work but unless Access for Web and HATS have changed they only accepted 13488 last I checked (when negotiating CCSID support). This may have changed over the last year or two.
UTF-8 (CCSID 1208) won't work as that is treated as character data (rather than graphic data) by the database and the high level languages.
You also need to change/recompile your *DSPFs as they also need to indicate that Unicode is being used. In my presentation my *DSPF was defined referencing my database definitions so changing the *DSPF was as easy as recompiling. You may or may not find it as easy.
As with the *DSPF you do need to at least recreate the RPG *PGM. And depending on how your application is coded you may, or may not, also need to make changes in the application source code. Some of these considerations are mentioned in my presentation.
But the objective of working with Japanese, PRC Chinese, and English (to mention just a few languages) in one 5250 session, simultaneously, has been possible for a few years now.
Bruce
Bruce Vining Services
507-206-4178
--- On Thu, 2/26/09, frank kolmann <fkolmann@xxxxxxxxx> wrote:
From: frank kolmann <fkolmann@xxxxxxxxx>
Subject: Re: iSeries Access for Windows and unicode
To: rpg400-l@xxxxxxxxxxxx
Date: Thursday, February 26, 2009, 8:40 PM
Hi Jeff
That is what is so amazing about this discussion point.
I also believed this was not possible.
In fact I have 3 PCs set up JAPANESE , PRC CHINESE and ENGLISH.
From what I see it IS possible to have ONE PC with Iseries
Access for the WEB installed, then recode the DDS so that the data is stored in UTF-8 or UTF-16 format, then recompile the RPG programs and you can show MULTIPLE LANGUAGES SIMULTANEOUSLY.
This is a HOLY GRAIL that I have been looking for for a long time.
That is how to code my RPG programs to handle MULTIPLE LANGUAGES SIMULTANEOUSLY.
I have not felt this excited for 30 years.
Bruce please correct me if I am mistaken. (I pray my hopes are not dashed.)
Frank Kolmann
date: Thu, 26 Feb 2009 09:10:36 -0600
from: jeffw@xxxxxxxxxxxxxxxx
subject: Re: iSeries Access for Windows and unicode
I dont think this is possible. The reason is because Iseries Access
uses
the
Windows client language pack. So if you cannot view the data in Windows
it will not work in Iseries Access. We have 2 systems one in Single
Byte
(English) and one in Double Byte (Chinese). I have to take Remote
Control
of
another pc that is DBCS to allow the Iseries Access. Hope this helps.
Jeff Williams
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
