SqlDbx Forum

malikoski

Member

Decimal separator

How I change a decimal separator "," to "." in results ??

sqldbxhelp

Administrator

Re: Decimal separator

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.

malikoski

Member

Re: Decimal separator

thanks. My decimal symbol in regional configurations is '.'. , but the results show me with ','.

Last edited by malikoski (2008-12-15 08:41:47)

sqldbxhelp

Administrator

Re: Decimal separator

This is strange.
What is your locale?
Are you running English version of Windows or localized?

malikoski

Member

Re: Decimal separator

I'm from Brazil. I'm using a portuguese version.

sqldbxhelp

Administrator

Re: Decimal separator

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

www.sqldbx.com/files/SqlDbxPersonalTest.zip

malikoski

Member

Re: Decimal separator

Sorry. I was on vacation. hehe
I tested, but the results show me with ','.

sqldbxhelp

Administrator

Re: Decimal separator

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

jweyrich

Member

Re: Decimal separator

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)

sqldbxhelp

Administrator

Re: Decimal separator

This looks very wrong.
What database you use?
What is your regional setting for decimal point and thousand separator?

sqldbxhelp

Administrator

Re: Decimal separator

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 = '.,'

jweyrich

Member

Re: Decimal separator

You're right, the problem is related to NLS_NUMERIC_CHARACTERS.
Thank you for the effort.

sqldbxhelp

Administrator

Re: Decimal separator

You can download updated test version from
www.sqldbx.com/files/SqlDbxPersonalTest.zip

malikoski

Member

Re: Decimal separator

Thanks... That's ok in last build.

Very good..

malikoski

Member

Re: Decimal separator

Sorry, but export results to excel isn't correct.

sqldbxhelp

Administrator

Re: Decimal separator

Can you provide more deatails.
What is incorrect?

malikoski

Member

Re: Decimal separator

The values in column VLR_MVTO not with "." .

I exported results in SQLDBX to Excel, and my decimal separator is ".".

sqldbxhelp

Administrator

Re: Decimal separator

I can see the issue now. Will be fixed in a next release.
Thanks

malikoski

Member

Re: Decimal separator

I can see the issue now. Will be fixed in a next release.
Thanks

Thanks...
That's ok now.