Re: Converting floats to ints with intval
| From: | Paul Waring | Date: | Thu, 06 May 2010 12:41:57 +0000 |
| Subject: | Re: Converting floats to ints with intval | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-304955@lists.php.net to get a copy of this message | ||
David McGlone wrote:
On Thursday 06 May 2010 07:19:48 Paul Waring wrote:Possible, yes. Practical, no. :) -- Paul Waring http://www.pwaring.comDavid Otton wrote: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.On 6 May 2010 11:52, Paul Waring <paul@xk7.net> wrote: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).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.