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

> At 09:00 PM 17/10/2003 +0000, you wrote:
> >Any idea why I get the error (above) when I try to create the table
> >below?
> >
> >CREATE TABLE jobhistory (jobnum INTEGER not null,
>
> >id VARCHAR(255) not null UNIQUE,
>
> this is your problem. A UNIQUE constraint creates an index. Index

width

> is limited to 253 bytes, less if you are using a non-binary

collation,

> composite fields or a multi-byte character set.
>

hi heLen,

does it means that if we are going to create an index key, the
combination field of the index must not > 253 bytes ?

rgds, chooi ting