Insert/update unicode data into a table
Posted: Fri Jun 04, 2010 7:09 pm
Can anyone tell me how to do insert or update an unicode value to the table.
This is the DBCS set for the characters
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?
This is the DBCS set for the characters
.â(<Ìì@<ó|Õ(±â) . <------ Taiwan (Chinese characters)
04447574C4E48454444440 <------ hex format
E2DC88CCEFFDF2D000000F
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?