What for a dist you use ? ubuntu or debian ? What for a error you get Is it the same as : http://issues.apache.org/jira/browse/JAMES-485
bye Norman Am Mittwoch, den 07.06.2006, 15:25 +0200 schrieb Craig Raw: > Hi, > > I'd like to point out to the list a problem with James and MySQL 4.1. The > character set support was > revamped from MySQL 4.0 to MySQL 4.1, and as a result on some systems (in my > case, Gentoo) UTF-8 is > now the default character set on install. > > This is a problem when creating the spool, inbox and deadletter tables. The > primary key for these > tables is (message_name, repository_name). On my system MySQL allows for 3 > bytes per UTF-8 > character, and has a maximum key length of 1000 bytes. Since message_name is > 200 chars and > repository_name is 255 chars by default, the key length exceeds 1000 bytes > and the table cannot be > created. > > The key length issue in MySQL is better described here: > http://www.xaprb.com/blog/2006/04/17/max-key-length-in-mysql/ > > I managed to solve the problem by reducing the length of repository_name to > 128 chars. > > Ciao, > Craig > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > >
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil
