Subject | Re: [firebird-support] Dear friends - Varchar size |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-11-01T21:14:14Z |
Ann W. Harrison wrote:
So I am not too crazy... What I thought was not 100% correct but ate
least has something to the current situation.
Thanks for the explanation Ann.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
>If you declare a varchar(10) and specify ahummm.
>variable length character set (e.g. UNICODE_FSS)
>Firebird allocated a 30 byte space plus the two
>length bytes. Firebird checks the byte length
>of the stored string, not the character length,
>so you can store up to 30 single byte characters,
>up to 15 two-byte characters, up to 10 three byte
>characters, and 7 four byte characters. You can
>also mix and match ... 6 single byte characters
>plus 5 three byte characters, plus 4 two byte
>characters...
>
>Regards,
>
>
>Ann
>
>
So I am not too crazy... What I thought was not 100% correct but ate
least has something to the current situation.
Thanks for the explanation Ann.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br