Re: [Semediawiki-user] utf8 in 1.2

[Markus K. <ma...@se...>]

On Mittwoch, 25. Juni 2008, Eugene Mednikov wrote:
> Currently we use SMW 1.1.2 and have some problems with non-english text:
> case-insensitive search don't work and sorting is wrong. Tried to set SMW
> tables collation to utf8_general_ci without success.
>
> Is there better utf8 support in new DB engine in SMW 1.2?

SMW 1.2 has the advantage that all sorting uses a single table column the 
collation of which could be set to achieve better sorting. This closely 
relates to the new sort key column -- I will check if we can have some 
parameter for setting this column's collation internally. 

SMW 1.1 uses SMW tables as well as MediaWiki tables for sorting operations. In 
general, I guess that you may need to rebuild table contents to make later 
collation changes take effect.

Regards,

Markus

P.S.: I recall that the "UTF8" option during MediaWiki installation is 
still "experimental" and has nothing to do with the above problem which 
refers to SMW tables only. Using Unicode characters in MediaWiki and SMW is 
possible in any case without special settings.

-- 
Markus Krötzsch
Semantic MediaWiki    http://semantic-mediawiki.org
http://korrekt.org    ma...@se...