Skip to Main Content

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!

UTF-8 hexadecimal

464944Jul 14 2010 — edited Jul 14 2010
hello, i need to convert string to UTF-8 hexadecimal form.

'Bratislava 4 Veternicová 11'

I need something like this

Bratislava%204%20Veternicov%C3%A1%2011

When I use
exec dbms_output.put_line(convert(utl_url.escape('Bratislava 4 Veternicová 11', true),'UTF8') );
result is
Bratislava%204%20Veternicov%E1%2011

Do you have any idea which conversion should I use in PL/SQL?

Thank you,

Jaro, Bratislava, Slovakia
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2010
Added on Jul 14 2010
1 comment
753 views