Hi,

At January-08-10, 3:56 AM, André Knappstein, Controlling wrote:

> I don't know.
> If I remember correctly I have read that unicode takes an extra byte
> per character and I did not want to hit any technical limit (max.
> lenghth of index key and such...)

UTF-8 can take between 1 and 4 bytes per character. The length of the
index key in FB 1.5 and up is a quarter of the page size(i.e.: for a
page size of 16KB, the maximum index key size will be 4KB).

> And I dimly remember that there were such limits for FB 1.5, which
> have been extended along with 2.x.

Here you are correct, with regards to index key size.  The only
limitation that existed in FB 1.5, that was basically removed from FB
2.0+, was the table size limit, which under FB 1.5 was 40GB/table and
is now(in FB 2.0+) a few TB/table.



-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)


------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to