0

By default, my ASP.NET project creates a table with the decimal column with "," delimeter. All decimals are stored in format "100,10". How can I change the delimeter to "."?

It causes problems with jQuery validation. JQuery thinks that it's not a number and the format of the field is wrong. I don't want to work around with jQuery.

enter image description here

enter image description here

Dale K
  • 25,246
  • 15
  • 42
  • 71
kostinalex
  • 75
  • 1
  • 7

2 Answers2

2

All decimals are stored in format "100,10"

This misunderstands what is happening. Sql Server stores decimal values in a binary format that is not human readable.

What you are seeing is more likely formatting applied by your query tool, reporting platform, or chosen by the culture settings in the operating system or process on the client system after data is returned from the database.

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
  • Please, see the images above. So there is no other way to deal with this problem than to fix everything in jquery? When I enter 100.10 in the field, it is stored as 0 in the database. – kostinalex Apr 01 '20 at 22:00
  • Not necessarily in jquery. You also have some C# and aspx markup, and you can sometimes address it at the IIS level, too. – Joel Coehoorn Apr 02 '20 at 00:46
0

You are confusing storage and representation.

SQL Server does not store "." or ",", it just stores a binary value.

The representation of decimal numbers in Visual Studio is controlled by your language settings in Windows.

The validation of jquery-validate (? you do not state which mechanism you are using) is controlled by configuration. See these answers, or the documentation of your library.

devio
  • 36,858
  • 7
  • 80
  • 143