Oracle DBA, How To, Error, Cause and Action

ORA-12713: Character data loss in NCHAR/CHAR conversion

ORA-12713: Character data loss in NCHAR/CHAR conversion


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.



Action:


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

No comments:

Post a Comment

Thanks for your comment.