Sort French Language in ABC Order (SQLite)

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?