MySQL and currency (euro format)

[edge]

I'm trying to code a small site with a search function on it.
One of the values that is can be search is the price of a product.

Till now I was stroring the price as a varchar() type, but this way it can not be used to do a search query with "BETWEEN". (example: BETWEEN 20 and 50)

Anyone here who can tell me what I should use as type in the MySQL?
Please note that the Dutch format of currency use is like this:
1.000,50 (one thousand euro and 50 cents) and:
25,75 (twenty five euro and seventy five cents)

Or.. Is there an other way of doing this?

Once again thank you for any info on this.

[falko]

I'd probably use DECIMAL. See http://dev.mysql.com/doc/refman/5.0/...ric-types.html

You can use the number_format() PHP function to convert the values into the right format.