Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2010-02-06 : 09:29:49
|
| I have a SQL Server 2005 database set to locale Turkish_CI_AS. The locale setting of the pc of the SQL Server is set to Turkish. Turkish decimal seperator is "," and thousands seperator is ".". There is a field with datatype decimal(14, 3) and it has a record with value "400,123" (that's four hundred). When I use Open Table in SQL Manager the value is correct in the result grid. But when I query the table in SQL query window the result value is "400.123" which is wrong. I also get this wrong result in my Linq query results. What should I do to get the correct value? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-06 : 10:37:41
|
run the below and check if db is using correct collationSELECT DATABASEPROPERTYEX('your db name','Collation') |
 |
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2010-02-08 : 06:54:07
|
quote:
Originally posted by visakh16
run the below and check if db is using correct collationSELECT DATABASEPROPERTYEX('your db name','Collation')
Just checked, it is correct.Any ideas? I'd appreciate any help. |
|
|
|
|
|
|
Wrong locale in SQL Query results