Subject Re: [ib-support] index key size
Author kokou Fostin
--- sugi <truesaint@...> a écrit : > Dear all,
>
> I asked a question some time in the past (IB 5.x)
> about the maximum
> allowed size of the PK, which was limited to around
> 200 characters in
> the default charset. I ran into another similar
> problem today, this time
> I have a varchar(255) field, and when I try to
> create a unique index on
> this field, FB complained about 'key size too
> large'.
>
> 1. Is this the same pk/index limitations? Or did I
> do something wrong?
> 2. Is there any workaround/fixes on the issue?
>
> TIA,
> sugi.
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

The maximum allowed size of the PK and index is 252
characters.


___________________________________________________________
Do You Yahoo!? -- Une adresse @... gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com