Re: order by what?

Robin Vickery wrote: > > > 2009/6/11 PJ <af.gourmet@videotron.ca > <mailto:af.gourmet@videotron.ca>> > > How can order by be forced to order alphabetically and ignore accents > without stripping the accents for printout? This is a problem for both > caps & normal letters. > > > Depends on the database. > > If you're using mysql, the order is governed by the collation used. To > get the order you want, you need a case-insensitive and > accent-insensitive collation. Exactly which one you use will depend on > the character set that you're using, but if you're character set is > utf8, then the utf8_general_ci collation should work: > > SELECT fieldname FROM tablename ORDER BY fieldname COLLATE > utf8_general_ci; > > -robin Nice thought, Robin. My collation is already uft8_general_ci. Adding that condition to the query changes nothing; and specifying another collation return a blank or null and the list is not echoed. Even changing the collation in the db does not change anything. Same wrong results. Thanks anyway. -- Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." ------------------------------------------------------------- Phil Jourdan --- pj@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php