Groups | Blog | Home
all groups > sql server programming > june 2004 >

sql server programming : Urgent help Needed - Please Read


Julie
6/28/2004 1:10:15 PM
Have you tried converting it to unicode, then changing
the system settings ?


[quoted text, click to view]
Rajib Chatterjee
6/28/2004 11:24:29 PM
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

Rajib Chatterjee
6/29/2004 10:55:36 AM
Hi, Thanks for prompt reply.

Can you please elaborate it further... We have an application front end
which is passing the data to Stored Procedure in the back end. Front end
changes the decimal places to COMMA automatically and try sending the same
data to back-end and SP fails to update the DB .

Regards
Rajib
[quoted text, click to view]

Tibor Karaszi
6/29/2004 12:24:07 PM
You need to make your client application send appropriate SQL to SQL Server. SQL Server does not
accept comma, so in this case, your client application has a bug as it cannot work with a different
regional setting.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


[quoted text, click to view]

AddThis Social Bookmark Button