SQL Server Home
Thank you for your feedback!
Some datatypes doesn't honor localization
- by SwePeso
This item may be valid but belongs to an external system out of the direct control of this product team.
A more detailed explanation for the resolution of this particular item may have been provided in the comments section.
1/14/2011 12:04:15 AM
Some datatypes doesn't use the correct decimal separator when presenting the result
ATTACH A FILE
EDIT THIS ITEM
Item can only be reassigned when it is active.
to post a comment.
Please enter a comment.
[MSFT] on 11/19/2012 at 12:03 PM
Thanks for following up. Unfortunatelly, right now, we don't have concrete plans or dates, but this is something we want to fix in the future
Sr. Program Manager
on 10/11/2012 at 12:49 AM
At least in Management Studio 2012 (Win 7, decimal separator , in windows regional settings) + SQL Server 2008 the following statement can be used to reproduce the problem:
select convert(float, 1.1), convert(numeric(2,1), 1.1)
The result will be: 1,1 and 1.1
Bas van Atteveldt
on 2/28/2012 at 11:51 PM
In order to reproduce it, apart from using the given script, set your locale to use a comma as a decimal seperator instead of a point.
[MSFT] on 1/5/2012 at 10:17 AM
Not yet. Are you blocked by this issue?
on 1/4/2012 at 10:39 AM
any progress on this?
We have the same behaviour when I use ssms2008 r2 to connect to an sql 2000 server.
[MSFT] on 12/7/2011 at 3:09 PM
Thanks for your feedback. We will evaluate this bug for a future release. Right now, you can reformat the values using the most appropriate FormatProvider class. Due to a infrastructure limitation, I'll be closing this issue and re-open it in a different database in order to track it better.
on 10/4/2011 at 12:03 AM
Same behaviour on SSMS SQL2008R2 SP1 :-(
on 2/27/2011 at 2:03 PM
If I change Regional Settings on the server to US English I too get consistent results.
But if I change back the Regional Settings to Swedish (comma is decimal separator) I get dot a decimal separator for DECIMAL and comma as decimal separator for FLOAT.
on 2/27/2011 at 8:25 AM
I could not repro this issue on SQL Server 2008 R2 or Denali using the script provided. Are their any other inputs/steps that I can try?
SQL Server Manageability
to post a workaround.
Please enter a workaround.
Attach a file
© 2016 Microsoft