Re: ATG 2006.3 with MySQL 5.x on Linux

Long term solution - ensure MySQL is using INNODB instead of MYISAM.

For example, this will work:
create table if_integ_data (
        item_id varchar(40)     not null,
        descriptor      nvarchar(255)   not null,
        repository      nvarchar(255)   not null,
        state   integer not null,
        last_import     datetime        null,
        version integer not null
,constraint if_int_data_p primary key (item_id,descriptor,repository)) ENGINE = INNODB

Whereas this will cause the error -
"ERROR 1071 (42000) at line 284: Specified key was too long; max key length is
1000 bytes"
create table if_integ_data (
        item_id varchar(40)     not null,
        descriptor      nvarchar(255)   not null,
        repository      nvarchar(255)   not null,
        state   integer not null,
        last_import     datetime        null,
        version integer not null
,constraint if_int_data_p primary key (item_id,descriptor,repository)) ENGINE = MYISAM



Awesome.  Thanks to Enrique Matta at ATG Support for that!