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 u
On 6/12/09 11:52 AM, "Eddie Drapkin" wrote:
> Correct me if I'm wrong, but should varchar 255 with a utf8 character set mean
> 255 unicode characters, not octets?
in mysql, the length refers to the storage space of the string, not the
decoded character count. i don't know about other dbms.
> O
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 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 the column.
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
str
4 matches
Mail list logo