Subject | Re: [ib-support] Index key length limits are very small |
---|---|
Author | Ann W. Harrison |
Post date | 2002-10-05T19:07:04Z |
At 05:50 PM 10/5/2002 +0000, fokubitch wrote:
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.
>I found that there is a limit of 84 characters on index key length whenNo, unfortunately, you can't change the limit. Index keys are limited
>using PXW_CSY collation. For compound index, it looks like total length
>of all columns together cannot exceed 66 charactes!!!
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.