Subject Re: [firebird-support] Allowing Space for Unicode
Author Milan Babuskov
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