How to fix the Oracle error ORA-12713: Character data loss in NCHAR/CHAR conversion?

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.