Re: [PDO] Mapping data type/size

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 ;)

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php