The manual is really a wonderful read - anyway:
char() 255 bytes
varchar() 255 bytes
text() 65535 bytes
-----Original Message-----
From: Emily Kelley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subject: question re: field size
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.
Thank you,
Emily Kelley
Research Assoc. / Historical Cartographer
Atlas of Historical County Boundaries
Newberry Library
Chicago, IL
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
