Display the content of a BLOB field

[bob1660]

I would like to execute a select query in PHP to return the text in a BLOB field. I have a Firebird 2.0 database. The BLOB field contains technical specifications on products. Can someone please help me with the sql sytax. When I query the BLOB field, it only returns an "image" and not the text.

 

[unclejimbob]

Not familiar with PHP over FireBird but I'll have a stab, the SQL syntax shouldn't really affect what you are doing, as long as you are doing something like this:

select my_blob from my_table where my_table_pk = x

Then as long as you have defined the BLOB sub type as text you should be able to get at it.

Here are some URLs I came across...

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_howto13

http://dn.codegear.com/article/images/27206/3506b.html#ibase_blob_open

ujb