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
Re: question re: field size
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
RE: question re: field size
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