Re: Encoding issue with ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



# jochem@xxxxxxxxxxxxx / 2007-01-24 16:58:51 +0100:
> currency values should be stored in the DB as integers (i.e. as penny
> based values).  no floats (so that you avoid any rounding errors) and
> definitely no currency symbols!
 
What about DECIMAL?

> if you need to store which currency the price/ammount is in then use
> a seperate field

Or use a smart database, see e. g.
http://archives.postgresql.org/pgsql-general/2005-08/msg01432.php

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux