In Brazil decimal separator=comma
SQL SERVER
LANGUAGE=BRAZILIAN OR PORTUGUESE
PRICE=MONEY
"UPDATE PRO SET PRICE='1,11' WHERE COD='0001'"
PRICE=111.00
all aplications use comma... impossible alter all!
Programmatically in SQL you will need to use a dot insted of a comma but the data can be displayed in the front using a comma provided you have the correct regional settings on the front end.
No comments:
Post a Comment