Problem with figures format - Spanish regional settings

• oscar.gordon

  Newbie

  Points: 7

  More actions

  May 9, 2008 at 1:30 pm

  #185215

  Hello,

  When I open the table through enterprise manager (right click on the table and open table/return all rows) I see the figures with the correct format ("," as decimal separator). However if I perform a simple query through the query analizer I get an incorrect format ("." as decimal separator and several digits after the "."). This is an example of what I see in both cases:

  Opening table: 2183,92

  Query: 2183.92000000000000000000

  The column is defined as decimal(17)

  The regional settings of the server are correct (Spanish settings with "," as decimal separator), as well as the SQL server settings (Intercallation Modern_Spanish_CI_AS, language Spanish, ...)

  Likewise, If I perform a query from a laptop through ODBC I get the same format.

  I would appreciate any help on this.

  Thank you very much

  Regards

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  May 30, 2008 at 3:44 am

  #822177

  Formatting is done by the client application, and - as you've already seen - there are differences between how data is displayed in EM and QA.

  Anyway, this does not affect how the data is stored and passed to the client. How do you control formatting in your client application?

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com