At 10:35 -0400 9/27/04, Little, Tim wrote:
>Is there a way to prevent VARCHAR fields from being automatically converted
>to TEXT fields. I have a few VARCHAR fields of around 200-300 characters
>(usually less) that I'd rather have in Memory Heap tables...
This conversion happens for VARCHAR(n) where n is larger than the maximum
length of a VARCHAR, which is 255.
To prevent the conversion, don't use n > 255.
>But since VARCHARs are often converted to TEXT after a certain length, this
>current structure is "immune" to heap storage.
>
>Any suggestions?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
