Hello.
> Would both of the above tables have 2^32 - 1 characters?=20
No. TEXT types are variable-length types. For each one, the storage
requirements depends on the actual length of column values, rather
than on the type's maximum possible size. See:
http://dev.mysql.com/doc/mysql/en/sto
?
Thank you,
Sunil Vishwas
-Original Message-
From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 23, 2005 12:29 PM
To: Sunil Vishwas
Cc: mysql@lists.mysql.com
Subject: Re: Need explanation on string data size and storage
requirement.
On Aug 23, 2005, at 10:20 AM, Sunil
On Aug 23, 2005, at 10:20 AM, Sunil Vishwas wrote:
I was looking into the storage requirement for the various data types
and
got confused by following comment:
'For the CHAR, VARCHAR, and TEXT types, L and M in the preceding table
should be interpreted as number of bytes before MySQL 4.1 and a
I was looking into the storage requirement for the various data types
and
got confused by following comment:
'For the CHAR, VARCHAR, and TEXT types, L and M in the preceding table
should be interpreted as number of bytes before MySQL 4.1 and as number
of
characters thereafter.'
Then I looked into
