CODEWITHSUNDEEP
sqlasp.netsql-server
kostinalex
kostinalex

Reputation: 85

How to change the delimeter from "," to "." in SQL database for the decimal column

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

Upvotes: 0

Views: 75

Answers (2)

Joel Coehoorn
Joel Coehoorn

Reputation: 415820

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.

Upvotes: 2

devio
devio

Reputation: 37215

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.

Upvotes: 0

Related Questions