Friday, January 27, 2012

"," (Comma) as Decimal Place - SQL SERVER 2000 /MSDE2000 does not work

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

No comments:

Post a Comment