|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
MySQL/MyODBC/Access 97 alpha-sorting doesn't work. PLEASE HELP.
From: Apollo (Carmel Entertainment) (lists
carmelme.com)
Date: Thu Nov 13 2003 - 16:33:15 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I have Mysql 4.0.14 with MyODBC3.51 and Access97.
I have a query
SELECT inquiry_data_simple.inquiry_id, inquiry_data_simple.organization,
inquiry_data_simple.event_date, inquiry_data_simple.event_id FROM
inquiry_data_simple ORDER BY inquiry_data_simple.organization;
The "organization" field does not sort alpha. Any ideas what could that be. It
is ONLY a problem on WindowsXP home systems. Other systems are just fine.
I have relinked the tables, re-installed the MSOffice and MySQL, done tons of
other stuff.
I have spent two days on this and I have no idea what else to do.
-------------------------------------------------
Visit CARMEL MUSIC & ENTERTAINMENT website http://carmelme.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]