Subject Re: unsuccessful metadata update, key size too big for index
Author h_urlaf
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Well, that explains a lot. This characterset uses 3 bytes/character.
> So you're max VARCHAR length - as a single column in an unique
> constraint - would be around 80, 82 or so. It's limited to 255
> of 250 bytes (cannot remember exactly).

Hmm. So is a CHAR instead of a VARCHAR better?

> > > I have no idea why this should help.
> >
> > I figured that each table would only have two constraints max.
>
> Oh no, you can have more :-)
>
> Each constraint uses its own auto-created index.

Ah, no, I meant: if I break up this table into multiple tables, each
would only *require* two constrainst max, and that that could maybe
fall within the 255 bytes limit (as inconvenient this setup may be).

Thanks,
Emiliano