MySQL version - 4.0.13 MySQL Control Center - 0.9.2 beta I'm interested in storing a lot of plain text. I know varchar2 has a limit of 255 characters. I want to store characters in excess of 800 and even closer to 1000.' I've tried varchar2, text and longtext. My size that I'm trying is 713 characters, including spaces. But, it is only storing 673 characters. I'm initially just inserting the data manually using MySQL Control Center. I have to insert using a text file.
How can I use a single data type to store large amounts of text? Or, do I have to break up the text? (I read that by using varchar, it can dynamically expand the space needed for storage. Is this correct? I tried varchar, but didn't work for me.) Thanks, Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
