Re: [PDO] Mapping data type/size

On 29.10.2009, at 16:34, Lester Caine <lester@lsces.co.uk> wrote:

Lukas Kahwe Smith wrote:

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

BUT - what use is that when there is no matching field type in the database? That was one of the problems I was trying to say but messing it up ;)

yeah. its impossible. either pdo would have to define a standard or it would have to be a config setting. not sure what this parameter even does atm. regards lukas