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