[OpenSER-Devel] Too long keys for UTF-8

[Peter Lemenkov]

2008/3/17, Jan ONDREJ (SAL) <ondrejj at salstar.sk>:
> Hello,
>
>   when trying to create openser mysql databases using UTF-8 as mysql default
>  encoding, create scripts fails with:
>
>  [ondrejj at work openserctl]$ openserdbctl create
>  MySQL password for root:
>  INFO: test server charset
>  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!
>
>  Can somebody lower some string lengths to avoid this problem?
>  I think UTF-8 is a preffered encoding for most cases.

Well known issue for us - take a look at that BZ item:

http://sourceforge.net/tracker/index.php?func=detail&aid=1605410&group_id=139143&atid=743020

Seemt that suggested solution isn't enough - my colleague created
another one simple patch, but he mails it directly to Bogdan-Andrei
Iancu instead of re-opening this Bugzilla ticket and this patch was
lost in tons of mails :)

His patch applied.
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: patch.txt
Url: http://lists.openser.org/pipermail/devel/attachments/20080317/cd183168/attachment.txt