Problem with PL/SQL Developer's order

[DanielNN]

Hi,
since 2007 i've used this program. But few months ago i got an error with the "order"(that little square) feature on NUMBER fields.
When i order it looks like this:

13.55
14.94
1500
152.1
166.9
17.74
1800
18.88

Its like it ignores any dots and do the order.
I've look any option at the program but i couldn't resolve this problem.

If someone can helps me...

I'm on a Windows 7 Professional 32 bits - PT-BR.
Tried the pl/sql dev. versions : 7.1.0.1337, 7.0.2.1076.
Working on a oracle 10g.

 

[PeterW]

It looks like you have checked the preference SQL Window/Number fields to_char. Can you verify this?

 

[DanielNN]

No,
Isnt this. I found this option unchecked after the problem. Tried checked but its order in 'character order', not in 'number order'.
The order i get is also different from 'character order'.
In my 'problematic order' 13.50 = 1350, but in 'character order' isnt the same, theres a DOT, and character order consider this.
Yesterday i installed a new oracle client, hopping was something about connection, but the same error happened again.

 

[Marco Kalter]

Have you perhaps changed the number format in the preferences (Tools > Preferences > User Interface)? Theoretically this should not cause sorting issues, but you never know.

 

[DanielNN]

Hi,
I figure out whats my problem. But dont know the solution.
The problem is. My result is a number with a dot(decimal). When i order at plsql its order in portuguese way, that means, dot is the thousand separator, and it doesn matter in order.
So, how can i change the decimal separator on results data???
Must come with a comma ",".

 

[Marco Kalter]

The number format can be changed though the preferences (Tools > Preferences > User Interface). By default it will be the same as your Windows number format.

 

[DanielNN]

Hi Marco,
I didnt see any option at number format in (Tools > Preferences > User Interface). Wheres exactly???
I get just:
(Tools > Preferences > User Interface)
-Options
-Toolbar
-Browser
-Editor
-Fonts
-PL/SQL Beautifier
-Code Assistant
-Key Configuration
-Appearance
-Date/Time (only has windows options is here).

Im using 7.1.0.1337 version.

 

[DanielNN]

Where is it exactly?

 

[Marco Kalter]

On the Date/Time page you can set the format.