SqlDbx
You are not logged in.
Pages: 1
How I change a decimal separator "," to "." in results ??
Offline
For formatting results SqlDbx uses decimal separator as specified in computer
regional settings. Currently there's no option to force "." as decimal separator.
However in some instances SqlDbx always uses "." as separator. For example
when generating SELECT/UPDATE/INSERT statements.
This issue comes up once in a while so there's a possibility that we will add an
option to force "." as decimal separator in a future release.
Offline
thanks. My decimal symbol in regional configurations is '.'. , but the results show me with ','.
Last edited by malikoski (2008-12-15 08:41:47)
Offline
This is strange.
What is your locale?
Are you running English version of Windows or localized?
Offline
I'm from Brazil. I'm using a portuguese version.
Offline
Couple of days ago new test version was released.
You can set option to always use "." as decimal separator
in this version. Go to Tools->Options->Results and check "Always use "." as decimal separator".
Offline
Sorry. I was on vacation. hehe
I tested, but the results show me with ','.
Offline
I am not sure what is going on here. Can you please send screenshots
of result tab, Options->Results and your regional number settings to
support [at] sqldbx.com
Offline
I found more problems related to separators. Tested on SqlDbxPersonal-3.26 and SqlDbxPersonal-3.28-TEST.
SqlDbx maintains the hundred/thousand separator between the mantissa and the decimal separator when the column type is NUMBER(x,y).
Also, it doesn't show the mantissa when it's 0, and the statements generated by the right-click menu "GENERATE" don't include the mantissa for these cases as well. Seems to be a general problem related to floating point types.
For example, if I have a column with type NUMBER(12,2), and a record with the column value 2909,39, in the result grid it shows 2.909.,39 instead of 2.909,39.
This screenshot shows the exact problem:
Can anyone confirm?
Last edited by jweyrich (2009-01-15 08:30:20)
Offline
This looks very wrong.
What database you use?
What is your regional setting for decimal point and thousand separator?
Offline
Ok. I was able to reproduce this behavior in Oracle.
It happens in when your regional settings have
',' as decimal point and Oracle has NLS_NUMERIC_CHARACTERS set to ',.'.
This issue will be addressed in a next release.
Currently you can fix it by issuing following statement after
connecting to database
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'
Offline
You're right, the problem is related to NLS_NUMERIC_CHARACTERS.
Thank you for the effort.
Offline
You can download updated test version from
www.sqldbx.com/files/SqlDbxPersonalTest.zip
Offline
Thanks... That's ok in last build.
Very good..
Offline
Sorry, but export results to excel isn't correct.
Offline
Can you provide more deatails.
What is incorrect?
Offline
The values in column VLR_MVTO not with "." .
I exported results in SQLDBX to Excel, and my decimal separator is ".".
Offline
I can see the issue now. Will be fixed in a next release.
Thanks
Offline
I can see the issue now. Will be fixed in a next release.
Thanks
Thanks...
That's ok now.
Offline
Pages: 1