Well, not sure ... in general, SMW and MW have rather similar ways of creating
tables, and normally they just come out having the same settings (it does not
matter if they use Swedish collation, as long as they use the same).
Collation does matter for string ordering operations (which are used
by MW, for sure). Using Swedish collation with Cyrillic texts surely
would lead to catastrophe, just ask any of Russian mysql developer.
Even with German language I really doubt that Umlauts and so on
have the same codes in different collations.
I believe that the observed problems stem from having a database where
settings
somehow changed between MW and SMW installation, so that SMW used other
default collation settings than MW used when making its tables. I assume it
should be possible to have a script that just changes the collation of all
text-fields in all tables to whatever value some admin wants.
It may be possible even though probably requires re-indexing.
Note that the UTF8-DB-encoding option (referring to the one offered during
install now) is considered experimental for MediaWiki.
Hmm.. AFAIK only UTF8-binary is considered experimental, not
utf8_unicode_ci. And MW surely uses UTF8 throughly it's core - it
doesn't even work without PHP mb_string extension.. How would the
mysql server suppose to store Cyrillic or Chinesse characters
in a table with a database charset that doesn't even have such
character codes defined! And with UTF8 posts you may enter these
characters any time, even if your wiki let's say English, Swedish or
German...
And choosing it
currently is a sure way to get these problems in any case. So to all you
users who read this message later: unless you are comfortable with compiling
your own DB servers as well, please be careful with such settings ;-) The
default settings should normally work.
I really wasn't comfortable with comiliing mysql myself, but after
some tough time with MW I've found it's the best way to do. But of
course be warned - configure has lots of options, some should be used,
some disabled, compile time is long, and even make install is not
enough - you have to run few scripts - to setup mysql master tables,
to setup init.d and so on...
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://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
___
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
