[OpenSER-Users] ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 1000 bytes

[Patrick Miccio]

You can also change the UTF-8 charset:

ENGINE=MyISAM DEFAULT CHARSET=latin1

works as well, just tried it.

cheers,

Patrick.



> Hi,
> When I try to create openser database (openserdbctl create) on Gentoo, I
> have the message:
> 
> INFO: creating database openser ...
> ERROR 1071 (42000) at line 2: Specified key was too long; max key length is
> 1000 bytes
> ERROR: Creating core tables failed!
> 
> I search when i can modify TABLE_TYPE but i not found.
> 
> Regards,
> Yazid