Character fields ....

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.

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