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!

changing '?' back to special character

user1751829Oct 21 2014 — edited Dec 9 2014

I have a database with US7ASCII character set. It has some special characters like Ñ which appear as ? etc. Using this

utl_i18n.raw_to_nchar(utl_raw.cast_to_raw(COLUMN_NAME), 'WE8MSWIN1252')

I was able to convert them to accented form.

In another database with collation WE8MSWIN1252, the same scripts does not work. result set comes as ? or ¿ for special characters. And same is true for database which has collation as ALT32UTF8, it appears are ? or

Does any one has an idea how to resolve this?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2015

Added on Oct 21 2014

#database-key-features, #globalization-support

8 comments

4,718 views