Re: [PDO] Mapping data type/size

On 28.10.2009, at 19:41, Lukas Kahwe Smith wrote:

On 28.10.2009, at 18:15, Lester Caine wrote:

Please bare with me ... I'm still trying to 'convert' from my normal way of working ;) PDO::PARAM_INT is available, but no other numeric formats? I've been working through all the options to map data types into the correct internal format, but I'm not having much luck. Numeric types would be better passed as numbers rather than strings, but the main problem I'm hitting here is how to know which field types from one database map to another. Such as 'BOOL' which is normally handled as a CHAR(1) in Firebird, and also the different numeric field sizes of FLOAT and the like. The bottom line is that we have to know the structure of the table before we can use it? We can't simply ask for those details from the database and adjust things acordingly?

Well bool is one of those examples that is hard to do, since many developers do it differently and most RDBMS do not support it natively. So some do BIT, others TINYINT, yet others CHAR(1) and some have a native type.

oh just learned there is a PDO::PARAM_BOOL http://php.net/manual/en/pdo.constants.php regards, Lukas Kahwe Smith mls@pooteeweet.org