MYSQL query did not order results mix char

Question

I have a table with id, surname etc., when I query order by surname I obtain something like this

A, B, C,... V, Z, Ć, Č, Č, Đ ...

where slavian char are ordered after finished western european alphabet

Mysql connection is set in utf-8. query is

SELECT * FROM table ORDER BY SURNAME ASC

how can i obtain an unique order like

A, B, C, Ć, Č, Č, Đ... V, Z

Thanks

Possible duplicate of [Mysql order by on column with unicode characters](https://stackoverflow.com/questions/18210189/mysql-order-by-on-column-with-unicode-characters) — Nico Haase, Jan 28 '19 at 09:15

score 0 · Answer 1 · answered Jan 28 '19 at 09:17

0

in this case you need to define your own Alphabet (or Order). To do so you can follow the answer to this question.

Hopefully it works with non-ascii signs.

answered Jan 28 '19 at 09:17

Shuumi

Not my case Shuumi thanks, this one is a grouped query ut i habe nothin to group... – Luca Frassineti Jan 28 '19 at 09:54

score 0 · Answer 2 · answered Jan 28 '19 at 09:20

0

What you need is to use proper collation, which provides necessary info about ordering strings. Here's how to use collate keyword:

SELECT * FROM table ORDER BY SURNAME COLLATE latin1_german2_ci

Here I used latin1_german2_ci as an example, find collation that matches your requirements.

answered Jan 28 '19 at 09:20

Michał Turczyn

Thank Michal but when i try this mysql error is #1253 - COLLATION 'latin2_general_ci' is not valid for CHARACTER SET 'utf8' – Luca Frassineti Jan 28 '19 at 09:52
Try other collation, that was just an example – Michał Turczyn Jan 28 '19 at 10:01
I know it, in fact if you see I used another colllation! The real problem is that i have the table in charset utf8... – Luca Frassineti Jan 28 '19 at 10:21
I solved using ORDER BY convert(surname using cp852) COLLATE cp852_general_ci Thank you very much – Luca Frassineti Jan 28 '19 at 11:00
@LucaFrassineti If my answer helped you finding solution, mark it as accepted (green check mark on the left) and optionally upvote :) Glad I could help – Michał Turczyn Jan 28 '19 at 11:10

2 Answers2