> Oops. Same old collation issue. I applied the fix given in [1]. I think some
> DB backup must have caused this.
The best way to get rid of these problems (which initially gave me a
lots of headache) is to stop using precompiled RPM or windows
installer versions of mysql server, which use latin1 charset and
swedish collation by default.

Instead, I configure mysql with the following options
./configure\
 '--with-charset=utf8'\
 '--with-collation=utf8_unicode_ci'\

and compile it myself.
The cons - you have to be a root (have colocation or something like
that).

Also, you may find an mysql access class of MW and patch it yourself
with
'SET collation_connection = utf8_unicode_ci'

MySQL is frustrating to don't use UTF8 by default.
Dmitriy


-------------------------------------------------------------------------
SF.Net email is sponsored by: 
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Reply via email to