MediaWiki sorting the Hebrew Alphabet

[Herouth Maoz]

Quoting Ira Abramov <Lists-Linux-IL at ira.abramov.org>:

> Quoting Herouth Maoz, from the post of Mon, 04 Apr:
>>
>> Which database are you using? As far as I know, both PostgreSQL and
>> MySQL are dependent on the usual libraries for their sorting algorithms,
>> and therefore on the variable LC_COLLATE.
>
> using MySQL and the collation is settable after the fact, but I'm not
> sure which table/column to change and to what.

As far as I can gather, you can sort with a specific collation, but  
this would mean going through the entire application and changing the  
SQL statements to use the COLLATE operator. I wouldn't go that way. I  
believe in order to solve the problem you have to set up your database  
with the proper collation to begin with - dump the database to text,  
re-create it with proper character set and collation, and then reload  
it.

I think utf8 and utf8_general_ci are supposed to work properly for  
Hebrew. You can always test it by creating a little database somewhere  
with the settings you expect to work, create a table, insert a few  
words in Hebrew, and select it with order by.