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.
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