David McGlone wrote:
On Thursday 06 May 2010 07:19:48 Paul Waring wrote:
David Otton wrote:
On 6 May 2010 11:52, Paul Waring <paul@xxxxxxx> wrote:
If I was designing the system from scratch, that's what I'd do.
Unfortunately this is an add-on to a legacy system where currency values
are already stored as strings in the database (yes, not ideal I know,
but you have to work with what you've got).
I don't know much about your situation, but it does sound like you
need to fix the root problem. I'd use a decimal type, and lean on the
database to do the maths.
As I said, unfortunately it's a legacy system, so I can't just change
the database to use a different type (there are dozens of columns set up
like this, with thousands of values already set).
Would It be possible to write a script to extract everything from that
database and insert it into a database with the correct columns and values,
then all you would need to do is change the db connection information.
Possible, yes. Practical, no. :)
--
Paul Waring
http://www.pwaring.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
