Sort French Language in ABC Order (SQLite)

Question

I have a list that I am trying to sort in Alphabetical Order. I have retrieved my database with SELECT DISTINCT Category FROM 'Main Database' ORDER BY Category asc'"

It correctly alphabetizes the category list but the letter É is at the very bottom of the list, right after T. Is there a way I can set it so the accent É is right after E in the english alphabet?

score 2 · Accepted Answer · edited May 23 '17 at 12:31

2

This has to do with collation. You need to select the correct one for either your table or column.

https://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html

check out this answer: MySQL Sort Order - Collation?

edited May 23 '17 at 12:31

Community

1
1

answered Apr 23 '15 at 18:06

dmgig

4,400
5
36
47

Thank you for this answer. Do you by chance know how to integrate this with SQLite? – chronotrigga Apr 23 '15 at 18:48
1

ooh, sorry my bad. I just assumed MySQL. You might take a look here: http://stackoverflow.com/questions/19906086/problems-ordering-sqlite-by-a-column-with-accented-characters-%C3%81 – dmgig Apr 23 '15 at 19:30

Sort French Language in ABC Order (SQLite)

1 Answers1