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

user_12149221 0
Viewed 1081

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.

coldfusion-11 coldfusion encoding oracle sql
1 Answers

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

user_122009880
Related