Hi,

> > 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?

Nope, same limit.

> > > > 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).

Ah no, it's not a matter of how many constraints, but the total size
of a single constraint.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com