How to choose right NLS_LANG?

[Matt Ors]

Hello

Please forgive me for asking here, since this is only slightly to DOA, but I believe you may be able to help.

My application is compiled using Delphi 10.2 Tokyo. In code we use the default UnicodeString type. Users of my application set NLS_CHARACTERSET in their Oracle databases to either EE8MSWIN1250 or AL32UTF8.

What would be the right NLS_LANG to set in my application? May I assume a specific one, or should I let the users decide?

Kind Regards
Matt

 

[Marco Kalter]

If the users can set the NLS_LANG, or even have no NLS_LANG defined, then this can lead to character set issues. If the database is EE8MSWIN1250 or AL32UTF8, you can use one of these 2 character sets and set the NLS_LANG environment variable in your application before making the first database connection.