In this post, you’ll learn more about the Oracle ErrorORA-12713: Character data loss in NCHAR/CHAR conversion with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-12713: Character data loss in NCHAR/CHAR conversion
Reason for the Error ORA-12713: Character data loss in NCHAR/CHAR conversion
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.
How to fix the Error ORA-12713: Character data loss in NCHAR/CHAR conversion ?
You can fix this error in Oracle by following the below steps
Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE.