Re: [PDO] Character fields ....

On 27.10.2009, at 12:37, Lester Caine wrote:

> I'll repost the problem that was stopping me moving forward with  
> pdo_firebird ... it's probably not a bug, but I would appreciate  
> some help in working out a way around it.
>
> MySQL and PostgreSQL use a TEXT field which is a long character  
> string. In Firebird ( and Oracle ) these are replaced with BLOB  
> SUB_TYPE TEXT ( CLOB in Oracle ). When taking code that has a MySQL  
> query with several TEXT fields, Firebird fails because PDO is  
> opening stream connections for the fields rather than simply  
> returning the strings as happens with MySQL. ( I think there is a  
> bug logged against OCI for this? )
>
> The simple question is - how do we create a generic query that will  
> access the data. It is somewhat fundamental to using many queries  
> and while one can get around it by using VARCHAR fields for all  
> text, that has different limits for each database.


Yeah, I agree it would be nice to be able to tell PDO to just pass  
through the stream all at once for small LOBs. Obviously the streaming  
API makes a lot of sense when working with really large data sets.  
MySQL unfortunately doesnt support streaming natively, so all apps  
written for MySQL by-pass the LOB streaming API.

regards,
Lukas Kahwe Smith
[email protected]