Re: text length in bytes or chars?

[Mike Hillyer]

The linked page explicitly explains this:

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. Lengths for these types in columns specifications indicate number of characters from MySQL 4.1 on. The number of extra bytes for recording lengths for variable-length data types is unchanged. For example, L+1 bytes to store a TINYTEXT value before MySQL 4.1 becomes L characters + 1 byte to store the length as of MySQL 4.1.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]
Mobile: [phone]
Blog: http://www.openwin.org/mike