SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert hexadecimal to character ?

330976Dec 1 2006 — edited Dec 1 2006

Hi,

I have the follwing statement

INSERT INTO TRC_BR (BR_BIJZ,BR_AANTDOC) VALUES (HEXTORAW('486574206164726573206973206F6E6A75697374'),1 );

Problem is the hextoraw.
I have defined BR_BIJZ as a nvarchar2(400) and after import I see the value 486574206164726573206973206F6E6A75697374 in the field BR_BIJZ

How to translate the field BR-BIJZ into characters ? (Original text was a mem-field in a dBase-table: "Het adres is onjuist" (without quotes).

Any reaction will be appreciated.

Leo

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 29 2006

Added on Dec 1 2006

4 comments

654 views