Re: [PDO] Mapping data type/size

On 29.10.2009, at 16:34, Lester Caine <[email protected]> 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