Re: text length in bytes or chars?
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.
Subject
Views
Written By
Posted
17337
September 04, 2005 07:55PM
7230
September 08, 2005 02:16PM
8019
September 08, 2005 07:07PM
4162
September 09, 2005 09:16AM
Re: text length in bytes or chars?
3956
September 11, 2005 08:48PM
3833
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.