NLS SETTINGS

[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

[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.

[gregor]

Hi!

If we have web asp.net application in which point to set OracleGlobalization.SetApplicationInfo?

Best regards, Gregor

[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.

[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