Re: DB2 UTF-8 fields used in RPGLE

Unless I have overlooked something the RPGLE UTF-8 field support is
more or less useless since it in reality only supports characters in the
jobs SBCS EBCDIC CCSID :-(

It would be far better that the DB just passed the data "as is bytes"
so it could be passed to either a the jobs SBCS EBCDIC field or to
a DBCS field by using a %BIF.

Why on earth didn't IBM not just copy the DBCS support to UTF-8
support? Maybe Barbara Morris can answer that question?


On Mon, Dec 30, 2013 at 1:56 AM, Bruce Vining <bvining@xxxxxxxxxxxxxxx>wrote:

UTF-8 fields are defined to database as character so, if your job CCSID is
NOT 65535, then the UTF-8 data is converted by database (rather than RPGLE)
to the job CCSID. If your job CCSID is 65535 then you should get the raw
UTF-8 encoding (1208). This conversion to the job CCSID is why I personally
prefer to use a graphic definition (1200, 13488) for Unicode data. Then any
conversion to EBCDIC (or other encodings) is entirely under my control.

Bruce Vining


On Sun, Dec 29, 2013 at 3:28 PM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

Has anybody tried that - it seems to me that UTF-8 fields are converted
to SBCS EBCDIC in RPGLE

--
Regards,
Henrik Rützou

http://powerEXT.com <http://powerext.com/>
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (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.

--
Regards,
Bruce
www.brucevining.com
www.powercl.com
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (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.