You might face the issue, that a SQL*Plus insert statement does not properly encode special characters (for example, German umlauts like ä, ö, ü) and consequently incorrectly store in the database.
To resolve this issue, do the following:
-
On the client where you run SQL*Plus, open the Environment Variables dialog.
-
Click New to create a new variable.
-
Type NLS_LANG in the Variable name box.
-
Type .AL32UTF8 in the Variable value box.
-
Click OK.