Hi, I'm not having any problem on my local computer
mysql> select text,text2 from table1 order by text2 desc; +------+-------+ | text | text2 | +------+-------+ | a | 1 | | � | 0 | +------+-------+ mysql>select text,text2 from table1 order by text2 desc; +------+-------+ | text | text2 | +------+-------+ | � | 1 | | a | 0 | +------+-------+ What Collation are you using? can you send us the table schema? thx! Isart On Thu, Jun 11, 2009 at 4:48 PM, PJ <af.gour...@videotron.ca> wrote: > Is there a way to order lists while ignoring the accents? > So far, I have found nothing simple; and I need to keep the accents for > output. > The language is French (and québécois) :-) > TIA > > -- > Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." > ------------------------------------------------------------- > Phil Jourdan --- p...@ptahhotep.com > http://www.ptahhotep.com > http://www.chiccantine.com/andypantry.php > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=isart.mont...@gmail.com > >
