Database connection, SQL and BLOB
Posted: 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
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