vendredi 1 mai 2015

French Language ABC Order in Javascript

I am building a web application using Javascript, HTML, and CSS. I have a table called categories I am pulling from my SQLite database called Main Database. The words are in french and the problem I am seeing is that letters with accents on top get sent to the bottom of the list instead of next to the normal letter they should be with.

enter image description here

JavaScript:

function listMainSymptomsDb(tx) {
    var category = getUrlVars().category;
    tx.executeSql("SELECT Main_Symptom, max(Add_Symptom) AS   
   `firstAddSymptom` from `Main Database` WHERE Category='" + category + "' 
    GROUP BY `Main_Symptom`",[],txSuccessListMainSymptoms);

Can anyone recommend a way I can order my letters correctly?

Aucun commentaire:

Enregistrer un commentaire