Database connection, SQL and BLOB

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Christian Lempereur
Posts: 14
Joined: Sun Nov 02, 2003 4:36 am
Location: Brussels

Database connection, SQL and BLOB

Postby 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,
christian

Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider], Yahoo [Bot] and 8 guests