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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,487 views