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

[Henning Westerholt]

On Wednesday 21 May 2008, Henning Westerholt wrote:
> > 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.
>
> Hi Yazid,
>
> are you using UTF-8 as server character set? If yes, then this problem was
> discussed some time ago at:
> http://lists.openser.org/pipermail/devel/2008-March/012765.html
>
> There is a patch that should solve this issue, i'll try to reproduce the
> problem.

Hi Yazid,

i just commited a fix to trunk and 1.3 branch. The UTF-8 charset is now 
correctly recognised during the DB setup, this should fix the problem.

Cheers,

Henning