Your are probably running into some limitation of MySQL Control Center. Maybe it's using GETs instead of PUTs. I haven't used Control Center, but I have input text much longer than 1000 characters through importing and the web via PHP. So the limitation is most likely with Control Center, it is still beta.
On Tuesday, November 4, 2003, at 11:01 AM, [EMAIL PROTECTED] wrote:
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
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
