How to store currency in european format?

sidsel

On a new project I work on I will often get a database dump in CSV format to import into a mysql table.

One of the columns is a pricefield which store a price in the european format ie. 145,95

Are there any other ways to store the price other than in a varcharfield?

planetsim

Yes, probably DECIMAL is best, DECIMAL with length 10, 2

sidsel

planetsim wrote:
Yes, probably DECIMAL is best, DECIMAL with length 10, 2

I have already tried that but 4,95 becomes 4.00 😕

planetsim

Is the comma necessary? I dont live in the Europe so not sure on exact formats they use. Mind you you could always replace the decimal point with a comma using DECIMAL.

sidsel

planetsim wrote:
Is the comma necessary? I dont live in the Europe so not sure on exact formats they use. Mind you you could always replace the decimal point with a comma using DECIMAL.

No the comma is not necessary in the endproduct but the CVS file come with the currency formatted in that way.