Re: Processing Multilanguage Data with YAJL, RPG and a PF

On Jun 10, 2016, at 10:31 AM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

I have encountered a situation where I am processing some JSON data with an
RPG program and Scott Klement's YAJL port.

The issue is the data I am processing could contain anything from English
to Russian to Chinese text.

The data, once processed, is stored in a PF.

So, the question is, what would be the proper way to:

1. Read the data in with YAJL
2. Define a PF field and store the data in a PF (is, UCS2, UTF-8, etc)
3. Allow an RPG program to read through this data and process is (ie, will
they need to use UCS2 fields, or iconv to convert it, etc).

What I tried was defining the field in the DDS as UCS2:

A VALUE 1000G CCSID(13488)

Then I process and store it:

val = YAJL_object_find(node:'value');
VALUE= yajl_get_string(val);

exec sql
insert into MYFILE(
VALUE)
VALUES(
:VALUE);
enddo;

Probably not correct, but my head is spinning from reading all the docs as
to how to handle this.

What I want to avoid is making the user's job run in a specific CCSID (such
as 65535 or 37).

Finally, how can I verify that the data is correct as a 5250 emulator
(using the latest IBM i Access) doesn't seem to display Chinese characters
properly to begin with.

Thanks!

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

Please contact support@xxxxxxxxxxxx for any subscription related questions.