Re: [Tutor] Mysql BLOB strangeness?
by Adam Cripps other posts by this author
Mar 17 2006 6:40AM messages near this date
Re: [Tutor] Mysql BLOB strangeness?
|
Re: [Tutor] Mysql BLOB strangeness?
On 3/17/06, Kent Johnson <kent37@[...].net> wrote:
> 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?
Thanks.
I'm using BLOB because I want them to be able to write content that is
longer than 255 chars.
Adam
--
http://www.monkeez.org
PGP key: 0x7111B833
_______________________________________________
Tutor maillist - Tutor@[...].org
http://mail.python.org/mailman/listinfo/tutor
Thread:
Adam Cripps
Brian Gustin
Adam Cripps
Brian Gustin
Adam Cripps
Kent Johnson
Brian Gustin
Adam Cripps
Kent Johnson
Adam Cripps
Liam Clarke
Brian Gustin
Adam Cripps
Hugo González Monteverde
|