Subject Re: [firebird-support] Dear friends - Varchar size
Author Alexandre Benson Smith
Marcelo Machado wrote:

>Please, could anybody answer?
>Is it necessary to define a maximum size for the field varchar?
>If I create a field varchar(10) cannot I insert more than ten characters?

If you define a field as varchar(10) the maximum allowed will be 10
characters, if you use multi-byte character sets than the value will be
small. FB 1.5 count the field size in bytes since multi-bytes uses more
than 1 byte then less characters could be stores in a 10 bytes field.

Read varchar(10) as "up to" 10 chars.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil