> Firstly, text is a reserved word in mysql. Secondly, varchars or chars
> can only have 255 characters. You should use a text type column which
> can be very large (megabytes!). You have read the manual on the
> different field types?
Clearly, he *did* read up on the field types in the manual and found
that a text field can hold 64k characters. He just didn't realize
that you don't set a length specifier on the text field.
> [EMAIL PROTECTED] wrote:
> >
> > Hi,
> >
> > I`m setting up a field in my DB called Description and
> > basically want it to
> > have a max character length of 1000, my MySQL manual tells me varchar is
> > limited to 255 so thats out of the window then it goes on to
> > say text has a
> > max of 64 kb of text and defines all the others in this way. I did try
> > entering as follows
> >
> > Description text(1000) but it isn`t accepting it
> >
> > should I be using something else??
Try without the length specification (i.e. drop '(1000)').
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
