IBM Mainframe Forum

[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

Select all

.â(<Ìì@<ó|Õ(±â)      .        <------ 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?

[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?

[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

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