Re: Intl address progress

[Javier Sanchez <javiersanchezbarquero@xxxxxxxxx>]

If your program is an embedded sql rpg:

Declare a variable like this:

dcl-s myUTF8Var char(50) ccsid(1208) inz;  // ccsid(*utf8) works too.

The char(50) is only illustrative, give the same length as your table's
1208 column.

Then in your program, assign whatever to myUTF8Var, even literal strings.
The compiler generates under the hood a call to a conversion routine that
would translate what you are loading it with as UTF-8 and then use this
variable to insert or update your field.  Personally I'd expect that not
doing this, the conversion should take place, but if not, better do this.

Try again and let us know.

El jue, 1 ago 2024 a las 8:34, Art Tostaine, Jr. (<atostaine@xxxxxxxxx>)
escribió:

> I created a CSV of FILEA with iACS SQL and it looks right. My program takes
> FILEA, Adds some data and creates FILEB. FILEB didn't download right. So
> something is happening when my program runs. I tried CHGJOB CCSID(*HEX)
> before I Ran it but that didn't work.
>
> Art
>
> On Thu, Aug 1, 2024 at 10:10 AM Javier Sanchez <
> javiersanchezbarquero@xxxxxxxxx> wrote:
>
> > Try this one first: with iACS, download the file to your PC and then
> > inspect it with Notepad++ and see if the character shows correctly.
> >
> > El jue, 1 ago 2024 a las 7:40, Art Tostaine, Jr. (<atostaine@xxxxxxxxx>)
> > escribió:
> >
> > > Thanks for the reply. It's 1208.  This is how it looks:
> > > Zhang ( )
> > >
> > > On Thu, Aug 1, 2024 at 9:29 AM Javier Sanchez <
> > > javiersanchezbarquero@xxxxxxxxx> wrote:
> > >
> > > > With option 8 using WRKLNK, check the CCSID that the stream file was
> > > > created with when imported with CPYTOIMPF and tell us back.
> > > --
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at https://archive.midrange.com/midrange-l.
> > >
> > > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
> related
> > > questions.
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.