I am trying to set up a new OTRS 3.0.3 schema in MySQL (to receive 3.0.3 data from MSSQL before I upgrade the server to 3.1). The relevant(?) my.ini excerpts are below: [mysql] default-character-set=utf8 [mysqld] character-set-server=utf8 default-storage-engine=INNODB sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" When I run the otrs-schema.mysql script I get two warnings (below). Are these harmless? Can I make a change to the OTRS configuration to avoid them? # ---------------------------------------------------------- # create table virtual_fs # ---------------------------------------------------------- CREATE TABLE virtual_fs ( id BIGINT NOT NULL AUTO_INCREMENT, filename TEXT NOT NULL, backend VARCHAR (60) NOT NULL, backend_key VARCHAR (160) NOT NULL, create_time DATETIME NOT NULL, PRIMARY KEY(id), INDEX virtual_fs_backend (backend(60)), INDEX virtual_fs_filename (filename(350)) ) 0 row(s) affected, 1 warning(s): 1071 Specified key was too long; max key length is 767 bytes # ---------------------------------------------------------- # create table virtual_fs_db # ---------------------------------------------------------- CREATE TABLE virtual_fs_db ( id BIGINT NOT NULL AUTO_INCREMENT, filename TEXT NOT NULL, content LONGBLOB NOT NULL, create_time DATETIME NOT NULL, PRIMARY KEY(id), INDEX virtual_fs_db_filename (filename(350)) ) 0 row(s) affected, 1 warning(s): 1071 Specified key was too long; max key length is 767 bytes