Database connection, SQL and BLOB

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
Christian Lempereur
Posts: 11
Joined: Sun Nov 02, 2003 4:36 am
Location: Brussels

Database connection, SQL and BLOB

Post by Christian Lempereur » Wed Jul 21, 2004 10:13 pm

I receive 'BLOB' as a result of a 'count(status)' in my SQL select statement.
TextPipe's Help says to try to use a subfilter with 'mime base64 encoding', I tried many of the possible encoding choices finally I got my result just using 'SUBSTRING(count(status),1,100)' instead of the 'count(status)'.

Data Base used was MySQL.

Thought it could be usefull for other members, as it is easy to implement.

best regards,

Post Reply