MAX VARCHAR Lenght

------=_NextPart_000_0029_01C70D75.B45FF230
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Can anyone explain what this means??

(The maximum effective length of a VARCHAR in MySQL 5.0.3 and later is =
determined by the maximum row size and the character set used. The =
maximum column length is subject to a row size of 65,532 bytes.)=20


If I'm using the Latin1 character set, how large can my VARCHAR column =
be in length? Is there a page to reference in the documentation?

Melissa=20

------=_NextPart_000_0029_01C70D75.B45FF230--

Re: MAX VARCHAR Lenght

Melissa Dougherty wrote:
> Can anyone explain what this means??
>
> (The maximum effective length of a VARCHAR in MySQL 5.0.3 and later
> is determined by the maximum row size and the character set used. The
> maximum column length is subject to a row size of 65,532 bytes.)
>
>
> If I'm using the Latin1 character set, how large can my VARCHAR
> column be in length? Is there a page to reference in the
> documentation?
>
Latin1 is 8-bit charset (1 byte = 1 character). If you define table which
only one varchar field have then this field can contain 65532 chars.

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org