Bug 109960 – dev-db/mysql-4.1.14 with USE="...utf8" has problem with mediawiki-1.3.16

• Status: RESOLVED UPSTREAM
• Product: Gentoo Linux

[Description Henri 2005-10-20 14:13:37 UTC]

dev-db/mysql-4.1.14 with USE="... utf8" has problem with mediawiki-1.3.16 

Problem can be solved by using USE="-utf8".

The bug is described by mysql.
http://bugs.mysql.com/bug.php?id=4541.

I'll hope this will help someone, but fixing to the bug is in upstream.

Reproducible: Always
Steps to Reproduce:

[Comment 1 Henri 2005-10-20 14:15:19 UTC]

I'll hope this will help someone, but fixing to the bug is in upstream.

[Comment 2 Henri 2005-10-20 14:25:45 UTC]

See also:
http://bugzilla.wikipedia.org/show_bug.cgi?id=1322

Given error message was:
Specified key was too long; max key length is 1000 bytes

[Comment 3 Francesco R. (RETIRED) 2005-10-22 10:52:35 UTC]

this is referred upstream as feature request 4541

http://bugs.mysql.com/bug.php?id=4541

lurking the commit mailing list look like something has been done for amd64
expanding the keys to 3000 bytes = 1000 chars in utf8 encoding.
however 5.0.13_rc amd64 still give an error:
#1071 - Specified key was too long; max key length is 1000 bytes

[Comment 4 Jakub Moc (RETIRED) 2006-06-22 08:08:59 UTC]

*** Bug 137548 has been marked as a duplicate of this bug. ***

[Comment 5 Jakub Moc (RETIRED) 2007-05-29 21:10:57 UTC]

*** Bug 180280 has been marked as a duplicate of this bug. ***