Subject Re: [ib-support] Index key length limits are very small
Author Ann W. Harrison
At 05:50 PM 10/5/2002 +0000, fokubitch wrote:

>I found that there is a limit of 84 characters on index key length when
>using PXW_CSY collation. For compound index, it looks like total length
>of all columns together cannot exceed 66 charactes!!!

No, unfortunately, you can't change the limit. Index keys are limited
to 255 bytes. Non-binary collations double or triple the key length,
depending on their complexity.

By the way, I'm not the most easily offended person in the world,
but your pseudonym could be taken as somewhat vulgar by an
English speaker.




Regards,

Ann
www.ibphoenix.com
We have answers.