Subject | Re: unsuccessful metadata update, key size too big for index |
---|---|
Author | h_urlaf |
Post date | 2004-02-05T12:57:40Z |
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
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
<m.tonies@u...> wrote:
> Well, that explains a lot. This characterset uses 3 bytes/character.Hmm. So is a CHAR instead of a VARCHAR better?
> 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).
> > > I have no idea why this should help.Ah, no, I meant: if I break up this table into multiple tables, each
> >
> > 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.
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