Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Decimal separator in Sql Server 2008

What do I need to change in Sql Server to be able to store values like "2,1" in a decimal field? Right now I have to have dots like "2.1".

I have Finnish_Swedish_CI_AS collation on the database but that doesn't seem to be it ... I also fiddled around with the regions settings on the server but with no success. I know I've managed to change this before.

like image 346
Riri Avatar asked Dec 30 '22 12:12

Riri


1 Answers

In security, your login properties, set default language to Finnish or Swedish. Although I'd prefer to format values into english standard and have default language set to english - this way storing data is independent of client regional settings.

like image 51
Arvo Avatar answered Jan 26 '23 04:01

Arvo