Yes, probably due to limitations of the Control Center. I also tried BLOB and I
get the same results.
Thanks
Brent Baisley
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
om> cc: [EMAIL PROTECTED]
Subject: Re: Column data type
maximums?
11/04/2003 10:21
AM
text would be more than enough to hold your data. a text column is
"limited" to about 65K characters.
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]
