I am on a project about Ecommerce in ASP and MSSQL Server. I coded a lot of pages.
Now, we want to support users to choose their own decimal symbol ("." dot or "," comma) in displaying and entering number (also currency).
If they choose "," and when enter number "123,34", then before insert into db, we must convert this number into "123.34" for MSSQL "understanding" this number. Because I coded a lot of pages, it's very hard to review all pages and do the conversion.
Do you have any experiences to do this with a minimum effort?