Lee Jenkins wrote:

> Dimitry Sibiryakov wrote:
>>> Can anyone offer general rules for setting size attributes of VARCHAR fields?
>> Length of varchar field is set in characters, not bytes. If some
>> English text contain 128 characters, why it must be twice longer in any
>> other language?.. I don't want to say that it can't be longer, but with
>> about the same probability it may be shorter.
>>
> My misunderstanding then. I thought it was for storage of the actual data as
> UTF8 can be 2 or more bytes per character, right?

Yes, but when you specify column size, it's in characters, not bytes.
For example, this:

create table t1 ( c1 varchar(100))

means that you can put 100 characters in column c1. Number of bytes
those characters would occupy depends on the character set.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com