Re: order by what?
| From: | Robin Vickery | Date: | Thu, 11 Jun 2009 15:06:43 +0000 |
| Subject: | Re: order by what? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-293935@lists.php.net to get a copy of this message | ||
2009/6/11 PJ <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