Internationalization and numbers between Samba and SQL

Version 4 V4 Question
1

I need some help here with , and . (decimal sep and 1000 sep).
I am using, and its working fine, the Resgister CASH saving option. So I am storing at the beginning and at the end of a work perido how much cash we have in the cash register and how much in CC.

My decimal separator everywhere is ,. All is working great. I have made a Report that shows CASH resgister Entities.

So far so good.

Now I decided to go one step further, and start doing some calculations with this. The problem I am facing is that samba (correctly) uses , as a decimal separator in my configuration.

Regardless what is your PC configuration, SQL stores decimal separator as a .. So when I try to convert Entities CustomData stored correctly with , SQL complains that its not possible to convert it to a number since it contains , and not .

The data stored in CustomData is:

[{"Name":"Apertura","Value":"97,15"},{"Name":"Cierre","Value":"689,05"},{"Name":"Tarjetas","Value":"43,80"}]

for those who are SQL experts… how can I convert 97,15 to 97.15?

THANKS!!!

G.

2

Not an expert on SQL but below link may provide some clues

3

ja… that is not my problem…

SQL refuses to convert 97,15 to 97.15 becuase the , is a special character and not a decimal separator.

Thanks!!!

G.

4

I´ve got it…

REPLACE('97,15',',','.')

That returns 97.15 from 97,15

THANKS!!!

G.

1 Like