java对mysql排序_Java排序与MySQL排序不同

I need to check the sorting in the table and table content is given by MySQL. I'm using the following row to sort the list:

Collections.sort(sorted, String.CASE_INSENSITIVE_ORDER);

And get the following result:

tes3@test.com

test4@test.com

test5@test.com

test@test.com

test_user@mail.com

user-og@driver.com

And this is what I get from MySQL by query:

SELECT 'email' FROM 'user' WHERE 1 ORDER BY 'user'.'email' ASC :

tes3@test.com

test_user@mail.com

test@test.com

test4@test.com

test5@test.com

user-og@driver.com

As you can see, the order is not the same.

Seems that Java sorts according to ASCII table:

http://www.asciitable.com/

4 (52) - @ (64) - _ (95)

But in MySQL result the order is _ -> @ -> 4

The email field collation is: utf8_unicode_ci

What is the problem and is there any comparator to make ordering in the same way?

解决方案

Use [Collator][1]:

The Collator class performs locale-sensitive String comparison. You use this class to build searching and sorting routines for natural language text.

And code will be:

Collator coll = Collator.getInstance(Locale.US);

coll.setStrength(Collator.IDENTICAL);

Collections.sort(words, coll);