Varchar sorts with mixed alphanumeric content

wilkenw

New Member
If I sort a mySQL varchar field containing alphanumeric data (e.g. 10/10/95) in my database using phpMyAdmin (e.g. SELECT field FROM table ORDER BY field), the data always appear in the correct order. If I attempt to sort the same data with Fabrik's field ordering capability, the data do not sort properly. Fabrik does, however, sort integer or all-text fields without a problem. Is there a workaround?
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top