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.

heLen