Print Thread
How to choose right NLS_LANG?
#62825 01/04/22 07:52 PM
Joined: Feb 2018
Posts: 16
M
Member
OP Offline
Member
M
Joined: Feb 2018
Posts: 16
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

Re: How to choose right NLS_LANG?
Matt Ors #62826 01/05/22 10:05 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
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.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.060s Queries: 15 (0.037s) Memory: 2.4949 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-28 14:53:16 UTC
Valid HTML 5 and Valid CSS