Martijn Tonies wrote:

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

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> No, you haven't got it straight yet. It is not the constraints, it
> is the limit on the size (width) of any index. The limit is 253
> BYTES (not characters). So, if you have a VARCHAR or a CHAR of 100
> UNICODE_FSS characters, it is too large to index.

Bingo! Thank you guys, got that now.

> To index those columns, you would have to reduce their size to
> VARCHAR(84) or less. CHAR is not a good type for variable data or
> for wide indexes, because it pads the data out to full width.

Dropping the size to 80 does work, thanks!

Emiliano