Re: DB2 UTF-8 fields used in RPGLE

At the risk of repeating myself, it's not RPG (and Barbara) doing this.
It's the database support/definition of UTF8 as being
character/alphanumeric. To get UTF-8 in an "as is bytes" form have your job
CCSID set to 65535 (though this of course may mess up other files in the
program where you do want job CCSID conversion).

And as mentioned previously, I tend to not use UTF8 in DB2 tables for just
this reason.


On Mon, Jan 13, 2014 at 6:59 AM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

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.

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