Database Software

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!

convert between utf8 and we8mswin1252 not work correctly

gipfelstuermerJan 13 2011 — edited Jan 17 2011

hi,

while debugging some application i've wondering about the SQL convert function. So i do some tests with german umlauts.

*1. Test with ü* (in UTF8 = 0xc3bc = 50108 , in Win-1252 = 0xFC = 252 ) :
select ascii(convert(chr(50108),'WE8MSWIN1252','UTF8')) from dual;
Result = 252
==> Everthing is OK. That's what i suggested.

*2. Test with ä* (in UTF8 = 0xc3a4 = 50084 , in Win-1252 = 0xE4 = 228 ) :
select ascii(convert(chr(50084),'WE8MSWIN1252','UTF8')) from dual;
Result = 0
==> What's this? I suggested 228 ?!?!?!

I've tested this on two Oracle-Server (lokal 10.2.0.2 with UTF8 and apex.oracle.com) with the same result.
Can anyone explain this behavior?

This post has been answered by Sergiusz Wolicki-Oracle on Jan 14 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2011

Added on Jan 13 2011

#database-key-features, #globalization-support, #sql

2 comments

1,264 views