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
) ;

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.