OraFAQ Forum: Client Tools » Regional settings (windows) damage sqldeveloper

Home » Other » Client Tools » Regional settings (windows) damage sqldeveloper (windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Regional settings (windows) damage sqldeveloper [message #322980]

Tue, 27 May 2008 00:10

arousset
Messages: 2
Registered: August 2005
Location: Venezuela

Junior Member

since microsoft pubished the patch for regional settings due to venezuelas change of hour, if i set time zone Caracas, sqldeveloper don't show numbers properly.
Has somebody any idea of how to workaround this?

Thanks in advance

Report message to a moderator

Re: Regional settings (windows) damage sqldeveloper [message #322987 is a reply to message #322980]

Tue, 27 May 2008 00:21

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Don't set time zone Caracas (if possible). As the world is divided into 24 time zones (15 degrees each), you might choose another city which is in the same time zone as Caracas.

Of course, it might be impossible if Hugo Chavez chose to lead the country in its own time zone. In that case, hm, no idea. Might it be that Microsoft's patch collides with Oracle?

By the way, what does it mean "sqldeveloper don't show numbers properly". How do numbers look like now?

Report message to a moderator

Re: Regional settings (windows) damage sqldeveloper [message #323241 is a reply to message #322987]

Tue, 27 May 2008 20:58

arousset
Messages: 2
Registered: August 2005
Location: Venezuela

Junior Member

well, Chavez did decided to lead the country in his own time zone, so we have to deal with that.
I think that yes, the microsoft patch collides with oracle sqldeveloper. Using others tools there isn't any change.

What happens -only in sqldeveloper- is that if I set time zone in Caracas, then when I execute a query over numeric fields, the ones that have commas are not shown. the result grid shows fields empty of values...

Report message to a moderator

Re: Regional settings (windows) damage sqldeveloper [message #323265 is a reply to message #323241]

Wed, 28 May 2008 00:13

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So he really did that?!? Hugo! /forum/fa/2115/0/

Hm, would it help if you modify NLS_NUMERIC_CHARACTERS? See this example:

SQL> alter session set nls_numeric_characters = '.,';

Session altered.

SQL> select to_char(1234.56, '999G999D99') from dual;

TO_CHAR(123
-----------
   1,234.56

SQL>

So - could you, perhaps, see whether it does any good in SQL Developer? I don't use it, but ALTER SESSION is a valid statement in TOAD (so I believe it might be executed in SQL Developer as well).

Anyhow: in NLS_NUMERIC_CHARACTERS = 'first_char second_char', the "first_char" is a decimal point character, while the second_char is a "thousands" separator. So, you may set it to ',.' or '.,' - test how it behaves.

Report message to a moderator

Previous Topic:	i cudnt use bind variables in toad ..pls find me a solution for this. .
Next Topic:	Access Discoverer Tables using SQL Developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 07:43:39 CST 2025