change the System settings to Swedish(Finland), the decimal space is a Comma

Hi All,
If we change the System settings to Swedish(Finland), the decimal space is a Comma "," instead of a Dot "." Now the problem is SQL Server does not recognize this and gives error. We can not do collation setting for numeric fields also.
Any help on the same will be highly appreciated.
RegardsSQL Server is not affected by regional settings. You have to give him dots
only.
There is no such thing like "collation setting for numeric fields".
Please read more about collations.
Bojidar Alexandrov
"Rajib Chatterjee" <rajibc@.hotmail.com> wrote in message
news:OpHbNuZXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> If we change the System settings to Swedish(Finland), the decimal space is
a
> Comma "," instead of a Dot "." Now the problem is SQL Server does not
> recognize this and gives error. We can not do collation setting for
numeric
> fields also.
> Any help on the same will be highly appreciated.
> Regards
> Rajib
>
>
|||SQL Server is not affected by regional settings. You have to give him dots
only.
There is no such thing like "collation setting for numeric fields".
Please read more about collations.
Bojidar Alexandrov
"Rajib Chatterjee" <rajibc@.hotmail.com> wrote in message
news:OpHbNuZXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> If we change the System settings to Swedish(Finland), the decimal space is
a
> Comma "," instead of a Dot "." Now the problem is SQL Server does not
> recognize this and gives error. We can not do collation setting for
numeric
> fields also.
> Any help on the same will be highly appreciated.
> Regards
> Rajib
>
>