Some datatypes doesn't honor localization

Posted by Peter Larsson on SQL Team See other posts from SQL Team or by Peter Larsson
Published on Fri, 14 Jan 2011 08:09:48 GMT Indexed on 2011/01/14 14:56 UTC
Read the original article Hit count: 325

Filed under:

This bug has haunted me for a while, until today when I decided to not accept it anymore.
So I filed a bug over at connect.microsoft.com,
https://connect.microsoft.com/SQLServer/feedback/details/636074/some-datatypes-doesnt-honor-localization, and if you feel the way I do, please vote for this bug to be fixed.

Here is a very simple repro of the problem

DECLARE  @Sample TABLE
         (
             a DECIMAL(38, 19),
             b FLOAT
         )

INSERT   @Sample
         (
             a,
             b
         )
VALUES   (1E / 7E, 1E / 7E)

SELECT   *
FROM     @Sample

Here is the actual output.

                                      a                      b
--------------------------------------- ----------------------
                  0.1428571428571428400      0,142857142857143
 

I think that both columns should have the same decimal separator, don't you?


//Peter

© SQL Team or respective owner