Oracle Database Express Edition (XE)

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 "NLS_NCHAR_CHARACTERSET AL16UTF16" to "UTF-8"?

525268Jul 27 2006 — edited Sep 10 2006

How can I convert the "NLS_NCHAR_CHARACTERSET AL16UTF16" to "UTF-8"?

Since Oracle XE (both W-European and UNIVERSAL) use an UTF-16 encoding for varchar characters by default I must also use this charste on my php page headers in order to print the special characters correct.

I need to switch to UTF-8 because I want to use PEAR::Quickforms which does noch support UTF-16.

- I tried to set several "ALTER SESSION ..." commands but nothing worked.
- I also reinstalled Oracle hoping I could change the encoding somewhere...
- I am out of ideas now ...

Any suggestions?
(If not I will probabliy step back from Oracle and return to MySQL)

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2006

Added on Jul 27 2006

11 comments

5,061 views