Re: CCSID - RPG issues
cesco via RPG400-L <[email protected]> Thu, 26 Feb 2026 09:15:36 +0000 (UTC)
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
Impossible to know without a minimally reproducible example.Your hex dump are a mix of french ccsid ebcdic and utf8.I personally just use UTF16 in files , put H CCSID(*UCS2:*UTF16) in the header , varucs2 for any internal var and all works idiomatically even in stock native io without any other particular provisions.
ciau
On Thursday, February 26, 2026 at 07:21:16 AM GMT+1, Gad Miron <[email protected]> wrote:
an update - (re)cheking
1. adding *NATURAL as 4th parameter to %subst did not solve the issue.
2. when comparing the Hex value of the source field (ds_NMMLIMP2.ITEMNAME)
in debug (EVAL ds_NMMLIMP2.ITEMNAME :x 512)
to the it's value in the (source) file
I've found they are NOT the SAME*.*
The value in debug is
00000 0036932F F0F5F3D4 D3E6F9D6 E9E491A8
00010 99C3E96D D8404040 40404040 40404040
00020 40404040 40404040 40400014 C380206C
00030 61206669 6E206465 206C27C3 A974C3A9
00040 20202020 20202020 20202020 20202020
The Hex value in the file is
349848894884973A3444444444444444
F031069504503DF3F000000000000000
Value of select HEX(ITEMNAME) from NMMLIMP2 is
C380206C612066696E206465206C27C3A974C3A9
the actual text is
À la fin de l'été
Hope anyone can make heads and tails of it
Gad
> date: Tue, 24 Feb 2026 09:29:25 -0500
> from: Barbara Morris <[email protected]>
> subject: Re: CCSID - RPG issues
>
> On 2026-02-24 8:56 a.m., Gad Miron wrote:
> > ...
> > // take first 128 chars of Item Description
> > ds_NMWRKR.ITEMNAME8 = %subst(ds_NMMLIMP2.ITEMNAME :1 : 128) ;
> >
> > // Update map file - target
> > update NMWRKR ds_NMWRKR ;
> >
> > C eval *INLR = *ON
> >
> > The update works but the value placed in ITEMNAME8 is erroneous
> > ...
> In debug, does ds_NMMLIMP2.ITEMNAME look correct before the %subst? Does
> it have UTF8 data? (look at the hex value of the field in the debugger)
>
> Does ds_NMWRKR.ITEMNAME8 look correct after the %subst?
>
> Is it always incorrect? Or does the problem only happen with some values?
>
> Using %subst with UTF8 data has the potential to only pick up the first
> byte of a 2-byte character unless you are using the new CHARCOUNT
> NATURAL support.
>
> https://www.ibm.com/docs/en/i/7.5.0?topic=functions-subst-get-substring
>
>
> https://www.ibm.com/docs/en/i/7.5.0?topic=cdt-processing-string-data-by-natural-size-each-character
>
> (I should update that pdf document to talk about the CHARCOUNT support
> that was added in 7.4 and 7.5 with PTFs.)
>
> --
> Barbara
>
>
>
>
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.
Please contact [email protected] for any subscription related questions.
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.
Please contact [email protected] for any subscription related questions.