Titanium Community Questions & Answer Archive

We felt that 6+ years of knowledge should not die so this is the Titanium Community Questions & Answer Archive

Special charcters javascript Sqlite

Hi!

I use SQLite to show some text from a database on a webview, but the text output look like this:

Avant de faire l'attraction remémorez vous l'histoire du film: Au début du XIXe siècle, un couple suisse et ses trois garçons,
craignant l'occupation des troupes de Napoléon, s'embarquent sur un
navire pour la Nouvelle Guinée. Une violente tempête se produit en mer.<br>

instead of this

Avant de faire l'attraction remémorez vous l'histoire du film: Au début du XIXe siècle, un couple suisse et ses trois garçons,
craignant l'occupation des troupes de Napoléon, s'embarquent sur un
navire pour la Nouvelle Guinée. Une violente tempête se produit en mer.<br>

Does anyone know how to parse theses characters?

Thanks ;

Ivan.

— asked September 16th 2010 by Ivan Mathy
  • iphone
0 Comments

2 Answers

  • hi,

    is everything in utf-8 (html metain your html file & sqlite encoding & most of all page encoding(check in you editor)) ?

    i use french caracters extracted from sqlite db and everything works.

    — answered September 16th 2010 by Stephane Pelamourgues
    permalink
    0 Comments
  • All is in utf-8, but the database entries have these characters…

    Is there a way to convert them?

    — answered September 16th 2010 by Ivan Mathy
    permalink
    0 Comments
The ownership of individual contributions to this community generated content is retained by the authors of their contributions.
All trademarks remain the property of the respective owner.