Subject | Re: [firebird-support] Index on character type column: CHAR or VARCHAR ? |
---|---|
Author | Ivan Prenosil |
Post date | 2004-09-17T14:22:41Z |
> Someone will correct me if I'm wrong but indexes are limited to 128 bytes,Maximum index key size is 252 bytes, but sometimes indexable data must be shoreter
(it depends on what collation is used, and whether the index is multicolumn).
See
http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm
Ivan