Re: how do i select and order by case insensitevly?
| From: | Manuel Lemos | Date: | Wed, 26 Jul 2000 09:02:03 +0000 |
| Subject: | Re: how do i select and order by case insensitevly? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1503@lists.php.net to get a copy of this message | ||
Hello Ed,
On 25-Jul-00 13:54:28, you wrote:
>Right now I do an order by name
>and it will do the following:
>APES
>BYLINE
>Bad
>asbestos
>etc.
>I want it to sort alphabetically, not using asc II values.
That's the usual sort mode for CHAR fields.
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@acm.org
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--