2008年8月1日星期五

Re: [fw-db] Why does DB return integers as strings?

2008/8/1 ardx <ovgray@rogers.com>:
> When I use it to query a table that has integer type columns, it returns the
> values of the column as strings. Why is that? Is it possible to configure it
> somehow so that integer values are returned as integers?

This was the standard behaviour also of the mysql_*() functions of
php. I never figured out an easy way to cast to the right data type. I
presume there's not a unique mapping from mysql data types to php
ones: for example the decimal (11.88 value) that stores an exact value
does not exist in php, that has only float...


--
Giorgio Sironi
Piccolo Principe & Ossigeno Scripter
http://www.sourceforge.net/projects/ossigeno

没有评论: