Insert Currency?

[barkster]

I'm trying to insert some currency into my table where the fields are set as double(16,2) What am I doing wrong, do I have the field set to the wrong type?

 

INSERT INTO Prices(Price,Shipping)VALUES('5,692.23','6,000.50')

 

Give me values of 5 & 6  If I don't have a comma then it works but why doesn't it work?  Thanks

 

[btherl]

Commas are not part of the "double" format.  So you need to remove them.  Simple

 

For currency, you may prefer to use the numeric or decimal type:

 

http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html

[bubblegum.anarchy]

Unfortunately, the following does not appear to work in mysql version [ 4.1.21-community-nt ]:

 

SELECT CONVERT('5,692.23', DECIMAL);

 

This following may be a good option:

 

INSERT INTO Prices (Price, Shipping) VALUES (REPLACE('5,692.23', ',', ''), REPLACE('6,000.50', ',', ''))