[Tutor] Mysql BLOB strangeness?

Adam Cripps kabads at gmail.com
Fri Mar 17 17:49:04 CET 2006


On 3/17/06, Kent Johnson <kent37 at tds.net> wrote:
> Adam Cripps wrote:
> > On 3/17/06, Kent Johnson <kent37 at tds.net> wrote:
> >>Why are you using a BLOB when the content is text?
> >
> > I'm using BLOB because I want them to be able to write content that is
> > longer than 255 chars.
>
> I'm no MySQL expert but the docs say VARCHAR fields can be up to 65,535
> chars.


65,535 for version 5.0.3 upwards - and I'm running version 4 - so it
appears that I'm stuck with Blob unless you know something that I
don't?

Adam
--
http://www.monkeez.org
PGP key: 0x7111B833


More information about the Tutor mailing list