For proper sorting using Glibc, it's not enough that the application use Glibc, but it should call the sorting function of Glibc too! (which apparently MySql does not).
behdad On Fri, 2 Jul 2004, Ehsan Akhgari wrote: > > You can do proper Persian sorting using either glibc > > (available in all GNU/Linux distributions), or ICU (available > > from http://oss.software.ibm.com/icu/). > > I have tested both MySQL 4.0.15 on WinXP and the default MySQL which comes > with Fedora Core 1, and neither could handle Persian sorting correctly. > They both seemed to start sorting from letter "FEH" to "YEH" and then > picking up "CHEH", "ZHEH", "GEH" and "PEH", and then starting from "ALEF" to > "GHEIN". > > It's possible that the Windows version has not been compiled with glibc, but > the Linux version is most likely compiled with glibc, I think. > > Do I need to compile MySQL manually? If so, is any particular version of > glibc required, or do I need to specify any particular compilation options? > > Thanks in advance, > > ------------- > Ehsan Akhgari > > Farda Technology (http://www.farda-tech.com/) --behdad behdad.org _______________________________________________ PersianComputing mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/persiancomputing