Page 1 of 1

Insert/update unicode data into a table

PostPosted: Fri Jun 04, 2010 7:09 pm
by syykwok
Can anyone tell me how to do insert or update an unicode value to the table.

This is the DBCS set for the characters

.â(<Ìì@<ó|Õ(±â)      .        <------ Taiwan (Chinese characters)
04447574C4E48454444440    <------ hex format
E2DC88CCEFFDF2D000000F


I have tried:

SET CURRENT ENCODING SCHEME = '0937' (this is the codepage for Taiwan characters)
UPDATE <table> set <column> = X'0E424D4C78587C4CCE4FEF4D8F425D4040404040400F'

but doesn't work.

Any advise?

Re: Insert/update unicode data into a table

PostPosted: Sat Jun 05, 2010 2:56 am
by dick scherrer
Hello and welcome to the forum,

but doesn't work.
If you want someone to help, you need to post more useful than "it didn't work".

What didn't work? Was there an sql error returned? Did something abend? How is this table/column defined?

Re: Insert/update unicode data into a table

PostPosted: Sat Jun 05, 2010 5:14 am
by syykwok
Thanks,

The SQL runs ok, but the character displayed is not in the correct format, i.e. cannot see Chinese characters (I use QMF for Windows to look at the record, and the character is just rubbish)

I have defined the table and tablespace as UNICODE, and allow the column is defined as MIXED CHAR, length is 3 times of its normal length

Re: Insert/update unicode data into a table

PostPosted: Sat Jun 05, 2010 11:05 pm
by dick scherrer
Hello,

Unload the table and look at the content of this column in hex. Using the Code tag, post a few of these values.