Hi guys...
UPDATE PRODUCT SET PRICE='1,11' WHERE COD='001'
but, in field "PRICE" = 111,00
I don′t need "." but i need to use ","
UPDATE PRODUCT SET PRICE='1.11' WHERE COD='001'
Works perfectly... but all sql commands in applications use ","
In Server
User′s set LANGUAGE=PORTUGUESES
DEFAULT LANGUAGE = PORTUGUESES
Tks All
If i'm correct then you are using money or decimal for price.
use varchar for price and use CHAR(44) for ',' and format the string.
No comments:
Post a Comment