RE: iSeries Access for Windows and unicode -- RPG400-L

Thanks for the response.

Worse luck - I'm currently having difficulty using iSeries Access for Web (configuration issue - looking at it).

However, from memory, when starting a session within iSeries Access for Web, a codepage had to be specified and there wasn't a unicode option ?? It was just the same codepages as within iSeries Access for Windows. I recall there was a unicode option for the web configuration, but not the session configuration. I did try UTF-8 on the web configuration but this not seem to help.

How do you define a UTF-8 codepage on the session ?

Your article proves that it can be done, I've obviously missed something.

Please help - this would be great to get working !

Regards,
Sean

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bruce Vining
Sent: 26 February 2009 16:11
To: RPG programming on the IBM i / System i
Subject: RE: iSeries Access for Windows and unicode

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.

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