How to handle umlaute like Ä Ö Ü in Coldfusion SQL query to insert into database?

I want to insert a string into my database with Coldfusion. However it contains umlauts like Ä, Ö and Ü (German). The umlauts are displayed different than they should in the database. For example I want to insert the value Eingefügt but in the Oracle Database it is Eingefügt.

Answer

Check the NLS_LANG settings in both the database and the client – odds are that either of the 2 (or both) are not configured to work with non-english characters.

select * from v$nls_parameters; is the command to do the db-level check