Re: how to insert hex data into UTF-8 column?

I'm guessing that by default it is expecting the hex values to be EBCDIC. This works:

insert into repcat52 ( catnum, catname, desc, desc_utf)
values( 1, 'WAVE', x'818283F1F2F3',
x'F1F2F3');

Rob, Birgitta or someone else who knows Run SQL scripts better than I will probably tell you there is an environment setting that controls this but I don't have time to look it up.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Mar 10, 2019, at 12:13 PM, Steve Richter <stephenrichter@xxxxxxxxx> wrote:

I have a column in a table set to CCSID 1208 ( utf-8 ). How to insert
x'313233' data into that column? ( x'313233' is ascii for 123. )

this insert statement does not work. The resulting value in the desc_utf
column is all garbled.
insert into repcat52 ( catnum, catname, desc, desc_utf)
values( 1, 'WAVE', x'818283F1F2F3',
x'616263313233')

where the table is declared like so:

CREATE or replace table repcat52(
catnum int not null default 0,
catName char(20) not null default ' ',
desc char(40) not null default ' ',
desc_utf char(40) not null default ' ' ccsid 1208
) ;
--
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@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com