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!

Replace a character in hexadecimal

user62721Dec 3 2011 — edited Dec 3 2011

Hi,

I need to replace a character (é) in a table
(in W8ISO8859P1 it is \0xe9, in AL32UTF8 it is \0xc3a9)

the database is in AL32UTF8

something like:

update tab1 set col1 = replace(col1, '\0xe9', '\0xc3a9')

but this doesn't work

how can I do that ?

Oracle 10.2.0.4

Thanks in advance

This post has been answered by Solomon Yakobson on Dec 3 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2011

Added on Dec 3 2011

1 comment

926 views