Obrigado Alexandre.

Marcelo

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?
>
>Thanks
>
>Marcelo
>
>
>

Marcelo,

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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




---------------------------------
YAHOO! GROUPS LINKS


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

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

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]