Tuesday, March 20, 2012

Problem whit "." or "," in field MONEY

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