At 2:24 PM +0000 12/2/99, Simon Freeman wrote:
>Thanks,
>As far as I understood what your response was you are suggesting I use TXT
>or Blobs. My point was that these add extra overhead to programming. This
>is important in web work. Is MySQL likely to increase its field size to
>above 255 char in varchar?
Yes, to 64K, but not yet.
What is the extra work?
>
>-----Original Message-----
>From: tonu@stripped [mailto:tonu@stripped]On Behalf Of Tonu
>Samuel
>Sent: 02 December 1999 11:49
>To: simon.freeman@stripped
>Cc: mysql@stripped
>Subject: Re: Varchar
>
>
>Simon Freeman wrote:
>
>> Currently running MS SQL vs 7. Want to migrate to mysql for cost reasons.
>> The problem is whereas MS SQL7 now supports varchar sizes of up to 2K
>Mysql
>> seems to be limited to 255.
>>
>> Will mysql be changed to allow large sizes.
>
>Look onto TEXT/BLOB/MEDIUMBLOB/etc datatypes.
--
Paul DuBois, paul@stripped