Quoting Ira Abramov <[email protected]>:
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.
_______________________________________________
Linux-il mailing list
[email protected]
http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
