Skip to Main Content

DevOps, CI/CD and Automation

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

341297Oct 17 2003 — edited Oct 21 2003
Oracle 9.2.0.4
PHP 4.3.3
data in db is in unicode UTF8
NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Then reading more than N Kb from CLOB I get ORA-24812.
If clob less than N Kb it's working fine.

On 9.2.0.1 SELECT convert(myclob, 'UTF16','AL32UTF8') causing instance crash.

Can you help me ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2003
Added on Oct 17 2003
5 comments
3,857 views