I believe I did this one time without changing the database schema; simply
by just putting the type in the ORDER BY clause.
ORDER BY BINARY numbers ASC
ORDER BY CAST(numbers AS BINARY) ASC
> -----Original Message-----
> From: J. Alejandro Ceballos Z. -JOAL-
> [mailto:[EMAIL PROTECTED]
> Sent: Sunday, June 18, 2006 7:01 PM
> To: email@example.com
> Cc: [EMAIL PROTECTED]
> Subject: [PHP-DB] re: mysql ORDER BY problems
> are they defined as integer or varchars (string)?
> a) exchange field definition varchar / integer
> b) order by length(number) and later by number
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php