From: Rick James
Date: May 30 2012 10:44pm
Subject: RE: sort order
List-Archive: http://lists.mysql.com/mysql/227562
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148724F121@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

"a" and "A" are identical, according to utf8_unicode_ci and utf8_general_ci=
, but not utf8_bin.
That is, I would not expect "[" to slip in between them.
About 80% of the way down this page, there is a list of some of the 'equiva=
lences' in selected collations:
  http://mysql.rjweb.org/doc.php/charcoll
In particular:
utf8 : utf8_unicode_ci                A=3Da=3D=AA=3D=C0=3D=C1=3D=C2=3D=C3=
=3D=C4=3D=C5=3D=E0=3D=E1=3D=E2=3D=E3=3D=E4=3D=E5  ae  az  =C6=3D=E6
says that lots of things collate equal to 'A'.  All of them sort before ae =
> az > the ligature =C6 (upper or lower case)

> -----Original Message-----
> From: Wes James [mailto:comptekki@stripped]
> Sent: Wednesday, May 30, 2012 2:03 PM
> To: mysql general discussion
> Subject: sort order
>=20
> I have mysql 5.1.62-0ubuntu0.11.10.1 installed, but the sort order for
> utf8-unicode doesn't seem to be right.  It is sorting some text like
> this (order by title):
>=20
> !
> ! *`-=3D[];',./~@#$%^&()_+{}|:"<>?\
> !"
> ![
> !@
> !a
> !A
> !t
> !test
> 'Coal age'
> [
> \--\
> 100 years
>=20
> when it should be (shouldn't it?):
>=20
> !
> ! *`-=3D[];',./~@#$%^&()_+{}|:"<>?\
> !"
> !@
> !A
> ![
> !a
> !t
> !test
> 'Coal age'
> 100 years
> [
> \--\
>=20
>=20
> ------------------------------
>=20
> Why is it doing this?
>=20
> Thanks,
>=20
> -wes