When you configured your session you should have selected (the default) of UTF-8. This is how you get the Unicode support. By specifying an EBCDIC CCSID you are disabling the Unicode support and reverting back to the limitations inherent of any one EBCDIC (or ASCII) CCSID.
Bruce
Bruce Vining Services
507-206-4178
--- On Thu, 2/26/09, McGovern, Sean <Sean.McGovern@xxxxxxxxxxxx> wrote:
From: McGovern, Sean <Sean.McGovern@xxxxxxxxxxxx>
Subject: RE: iSeries Access for Windows and unicode
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Date: Thursday, February 26, 2009, 9:33 AM
That's interesting.
I did think that iSeries Access for Web would be the solution. I tested this last week and had the same problems as each iSeries Access for Web session still has to be defined with a code page (the same list as within iSeries Access for Windows). If I configured a session as code page 285 (UK) and within that session used STRSQL and an INSERT statement to insert Hungarian text into a unicode table, I could initially see the correct Hungarian text within the INSERT statement but the data did not get written correctly to the database file as it was going through the 285 layer and losing Hungarian specific characters. Using the same INSERT statement from within an SQL script within iSeries Navigator correctly inserted the data into the table.
I will read your article and come back with questions.
Thanks,
Sean
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bruce Vining
Sent: 26 February 2009 15:04
To: RPG programming on the IBM i / System i
Subject: Re: iSeries Access for Windows and unicode
There are two products that I am aware of that take advantage of the 5250 datastream support for Unicode. They are iSeries Access For Web and HATS.
My COMMON presentation, What's With These ASCII, EBCDIC, Unicode CCSIDs, at
http://www.brucevining.com/Presentations/PPT_Presentations/Whats_with_these_ASCII_EBCDIC_Unicode_CCSIDs.pdf uses iSeries Access for Web when concurrently showing Russian, Chinese, German, and English on the 5250 *DSPF. The same program was used for testing and demonstration of HATS by the HATS support area :)
Other products may also support the 5250 based Unicode data stream. I'm simply not aware of them.
Bruce
Bruce Vining Services
507-206-4178
--- On Thu, 2/26/09, McGovern, Sean <Sean.McGovern@xxxxxxxxxxxx> wrote:
From: McGovern, Sean <Sean.McGovern@xxxxxxxxxxxx>
Subject: iSeries Access for Windows and unicode
To: rpg400-l@xxxxxxxxxxxx
Date: Thursday, February 26, 2009, 7:58 AM
Is it possible to setup 1 iSeries Access for Windows session that is capable of viewing/maintaining ALL possible data held in a unicode defined database ? Or is a separate session required (with appropriate
configuration) for each language ?
Regards
Sean McGovern
--
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
