Character data loss in NCHAR/CHAR conversion

Solution ID:ORA-12713

Type: Oracle

Cause

When character set conversion happens between CHAR and NCHAR either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.

Actions

Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


http://docs.oracle.com/cd/E16655_01/server.121/e17750/ch7progrunicode.htm


http://docs.oracle.com/cd/E16655_01/server.121/e26079/olap33k.htm


https://community.oracle.com/message/4266930


https://community.oracle.com/message/1483987


https://community.oracle.com/message/7422919


Browse all solutions to database errors from Oracle, MS SQL, or MySQL