MySQL Forums
Forum List  »  Docs

text length in bytes or chars?
Posted by: KimSeong Loh
Date: September 04, 2005 07:55PM

According to http://dev.mysql.com/doc/mysql/en/storage-requirements.html
It seems to say that TEXT is counted as characters instead of bytes, does TEXT allows 65535 bytes or 65535 characters?
There is also this example on the page
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.

I vaguely recall that TEXT is still counted in bytes and not characters.

Options: ReplyQuote


Subject
Views
Written By
Posted
text length in bytes or chars?
17261
September 04, 2005 07:55PM
7203
September 08, 2005 02:16PM
7973
September 08, 2005 07:07PM
4128
September 09, 2005 09:16AM
3927
September 11, 2005 08:48PM
3803
September 11, 2005 09:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.