开发者

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 da开发者_运维知识库tabase 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.


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.


Store the data as a regular number - change it only when you display it.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜