eddie,
you were quite right and i was wrong.
after discovering that the longest utf8 varchar column that mysql will allow
is varchar(333), i did some tests. on a varchar(255) column, mysql allows
strings with up to 255 utf8 characters to be inserted. and it truncates at
255 characters observing
say a table in the db has a varchar(255) column, 255 being the max number of
octets of strings that can go in the column. now say the php script very
occasionally has to deal with utf8 input strings with octet length 255 --
it needs to select rows matching the input string or insert the input
Correct me if I'm wrong, but should varchar 255 with a utf8 character set
mean 255 unicode characters, not octets?
On Fri, Jun 12, 2009 at 11:50 AM, Tom Worster f...@thefsb.org wrote:
say a table in the db has a varchar(255) column, 255 being the max number
of
octets of strings that can go in
3 matches
Mail list logo