Subject Re: [firebird-support] Dear friends - Varchar size - Thanks!
Author Marcelo Machado
Obrigado Alexandre.


Alexandre Benson Smith <iblist@...> wrote:
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


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at



Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


Yahoo! FareChase - Search multiple travel sites in one click.

[Non-text portions of this message have been removed]