From: Paul DuBois
Date: March 13 1999 2:37pm
Subject: Re: How many characters are possible?
List-Archive: http://lists.mysql.com/mysql/162
Message-Id:
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
At 8:09 AM -0600 3/13/1999, Thorsten Weigl wrote:
>Hi,
>
>what is the maximum of characters in one field. I have to fill one field
>with a text (round about 1.000 characters). If it is not possible, what
>would be the solution?
CHAR and VARCHAR are limited to 255 characters. You probably want a
TEXT field. See chapter 7 of the MySQL manual, particularly:
http://www.mysql.com/Manual_chapter/manual_Reference.html#Column_types
and
http://www.mysql.com/Manual_chapter/manual_Reference.html#Storage_requirements
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Madison Black Wolf: http://www.primate.wisc.edu/people/dubois/blackwolf/