2009/6/11 PJ <af.gour...@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;