MySQL and currency (euro format)
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.