Page 1 of 1
NLS SETTINGS
Posted: Tue 29 Mar 2011 20:45
by gregor
Dear!
If using direct mode is it possible to set NLS Settings at connection level or string. If not, please give us link how to check and set database NLS settings... We are using Oracle 10g and connection via direct mode. Everything works, except sorting is wrong.
Best regards, Gregor
Posted: Wed 30 Mar 2011 14:18
by StanislavK
You can change NLS settings at several different levels:
- for the whole system, you can change regional settings in the 'Control Panel' -> 'Regional and Language Options' window;
- for the application, you can specify NLS settings via the static
OracleGlobalization.SetApplicationInfo method;
- for the current session only, you can use the
OracleConnection.SetSessionInfo method.
Please tell us if this helps.
NLS LANGUAGE
Posted: Wed 30 Mar 2011 16:08
by gregor
Hi!
If we have web asp.net application in which point to set OracleGlobalization.SetApplicationInfo?
Best regards, Gregor
Posted: Thu 31 Mar 2011 15:50
by StanislavK
You can set the application info, e.g., in the Application_Start method of the Global application class:
http://msdn.microsoft.com/en-us/library/2027ewzw.aspx
Feel free to contact us if you have any additional questions.
NLS SETTINGS
Posted: Thu 31 Mar 2011 15:58
by gregor
Dear!
Of course, I didn't thought of this, since I do not set a lot of things in application level....
))
Thank you, that's it
)
Best regards, Gregor