[Tutor] Mysql BLOB strangeness?

[Kent Johnson]

Adam Cripps wrote:
> I'm trying to build a mini-CMS for my class to manage a single
> webpage, using CGI and mysql. The children will be storing their main
> content in a BLOB within a Mysql database.
> 
> When I query the content column, I get a strange return like this:
> 
> array('c', 'This is a test ')
> 
> - when the only text I entered in was 'This is a test'.

MySQL is apparently returning an array.array object, not a string. Just 
call tostring() on it to get a printable string.

Why are you using a BLOB when the content is text?

Kent