At 02:34 PM 1/30/2002 -0600, Emily Kelley wrote: >In the process of searching for a dynamic database solution for a work >project I have just begun reading about MySQL. So far this looks like a >very promising choice for us but I have one extremely basic question that I >hope someone will kindly answer for me. > >Is there a character limit for text fields? Our current database info has >been constructed in MS-Access 97 and we have a real problem with the fact >that a text field is limited to 255 characters. We frequently have >descriptive text and citations that can run over this length so it is a >crucial that we find a system that will allow us to include all the related >information for the documented event.
From the MySQL Reference Manual: "You can declare a VARCHAR column to be any length between 1 and 255." "BLOB, TEXT L+2 bytes, where L < 2 ^ 16" As 2 ^ 16 = 65536, it looks like you can store up to 64K of text in a MySQL text column. --------------------------------------------------------------------- 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