NLS SETTINGS

NLS SETTINGS

Postby gregor » Tue 29 Mar 2011 20:45

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
gregor
 
Posts: 10
Joined: Sat 25 Dec 2010 15:55

Postby StanislavK » Wed 30 Mar 2011 14:18

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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

NLS LANGUAGE

Postby gregor » Wed 30 Mar 2011 16:08

Hi!

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

Best regards, Gregor
gregor
 
Posts: 10
Joined: Sat 25 Dec 2010 15:55

Postby StanislavK » Thu 31 Mar 2011 15:50

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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

NLS SETTINGS

Postby gregor » Thu 31 Mar 2011 15:58

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
gregor
 
Posts: 10
Joined: Sat 25 Dec 2010 15:55


Return to dotConnect for Oracle