MySQL Forums
Forum List  »  Docs

Re: text length in bytes or chars?
Posted by: KimSeong Loh
Date: September 11, 2005 08:48PM

Still the same with 4.1.14.

TINYTEXT allows only 255 bytes and not 255 characters, tested with utf8, data truncation occurs when 100 3-byte utf8 characters is inserted.

VARCHAR(255) allows 255 characters, no truncation when 100 3-byte utf8 characters is inserted.

Both TINYTEXT and VARCHAR(255) column has been created with utf8 character set.

Options: ReplyQuote


Subject
Views
Written By
Posted
17148
September 04, 2005 07:55PM
7166
September 08, 2005 02:16PM
7883
September 08, 2005 07:07PM
4091
September 09, 2005 09:16AM
Re: text length in bytes or chars?
3886
September 11, 2005 08:48PM
3762
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.