Scientific Notation on float datatype

• Thomas Lorenzon

  Newbie

  Points: 8

  More actions

  March 22, 2006 at 9:58 am

  #167528

  I changed my SQL Server 2000 from an Italian version (sp3) to an English version (sp4).

  Now if i make a select avg(z) as x from table (where z is float) the result is a number with scientific notatio 1,123456E+48

  When i used italian version it looks like 112,3456.

  Someone known why?

  Thanks, Thomas

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  March 24, 2006 at 3:23 am

  #628537

  I really don't know, perhaps there is some differences in language settitngs or the windows locale settings..?

  Is this what you see in QA or in some other app? The use of a comma instead of dot for decimalpoint suggests that it may be some display conversion involved..

  Though just guessing.

  /Kenneth

• Thomas Lorenzon

  Newbie

  Points: 8

  More actions

  March 25, 2006 at 5:32 am

  #628772

  I usually use vb script inside asp but i tried also with QA and results are the same (scientific notation with english version, comma with italian version).

  There is no custom windows locale settings (I used default settings: comma as decimal separator in italian settings and dot in english version)...

  Thanks, Thomas