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

[Alan Langford]

Since the message_id and app_name are part of the language independence, 
why not just restrict them to the latin1 character set so they continue 
to use one byte per character? A Chinese (for example) message_id seems 
a little too flexible to me... leave the UTF character sets for fields 
likely to have human readable (rather than developer readable, grin) text.

On 2006 04 22 11:01, Sigurd Nes wrote:
> 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
>
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-developers