MySQL Forums
Forum List  »  Microsoft Access

[solved]different string sort order
Posted by: Marcel Pallarz
Date: June 24, 2013 06:44AM

Hello to all the experts,

I get different orders by sorting text in Access and MySQL.
For example:

'00154'
'_00154'
'#00154'

will be sorted as

'#00154'
'_00154'
'00154'

in Access and

'#00154'
'00154'
'_00154'

in MySQL. For comparing the data, I need the same order.
Please can anyone guide me?

Thanks,
Marcel



Edited 1 time(s). Last edit at 07/22/2013 03:25AM by Marcel Pallarz.

Options: ReplyQuote


Subject
Views
Written By
Posted
[solved]different string sort order
1941
June 24, 2013 06:44AM
1145
July 08, 2013 06:50PM
1090
July 22, 2013 03:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.