Re: [Phpgroupware-developers] HEAD: mysql / max key length for utf8

[Sigurd Nes]

That would restrict the installation to only one language.
(this is only tested on windows/MySQL 5.0.18 - I think pre 4.1 - one 
cannot specify utf8 (utf8_swedish_ci) as collation)

Regards

Sigurd

Dave Hall wrote:
> We should change the pk to be message_id, app_name imo
>
> Cheers
>
> Dave
>
> On Fri, 2006-04-21 at 18:14 +0200, Sigurd Nes wrote:
> > Problem:
> > The PRIMARY KEY ( message_id, app_name, lang ) of table phpgw_lang is to 
> > long (max key length is 1000 bytes) when creating database as utf8 with 
> > Mysql.
> >
> > regards
> >
> > Sigurd
> >
> >
> > _______________________________________________
> > Phpgroupware-developers mailing list
> > address@hidden
> > http://lists.gnu.org/mailman/listinfo/phpgroupware-developers