Skip to Main Content
Forums

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!

ORA-24812 character set conversion to or from UCS2 failed

361551May 10 2006 — edited May 11 2006
I have a CLOB column in a database table. The NLS_CHARACTERSET parameter of this database is set to AL32UTF8. The NLS_LANG from the UNIX environment is set to GERMAN_GERMANY.AL32UTF8. I put some UTF-8 encoded text with some German umlauts in this column using sqlplus. I have no problem to see the correct text using sqlplus on Unix and PL/SQL Developer on Windows. If I start my OCI program I get following message from the database:

ORA-24812: 24812 character set conversion to or from UCS2 failed


My locale is
locale
LANG=de_DE.UTF-8
LC_CTYPE="de_DE.UTF-8"
LC_NUMERIC="de_DE.UTF-8"
LC_TIME=C
LC_COLLATE="de_DE.UTF-8"
LC_MONETARY="de_DE.UTF-8"
LC_MESSAGES=C
LC_ALL=

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 8 2006
Added on May 10 2006
#database-key-features, #globalization-support
6 comments
8,701 views