UTF-8, Unicode and other languages (SQLite)

Discussion in 'Questions (Windows Mobile)' started by Nkieto, May 3, 2007.

  1. Nkieto

    Nkieto Member Licensed User

    More SQL ;)

    Since I am from Spain, in my language we have special caracters like (ñ, á, é, í, ó, ú). I have make some SQLite tables with SQLite Administrator using this special caracters, but when I make query from Basic4pcc I get missing caracters.

    For example: Marañón -> Maran

    I have no idea where is the problem... In my SQL tables? or in Basic4pcc? :confused:

  2. Nkieto

    Nkieto Member Licensed User

    I think problem is on my SQLite Administrator, because If I use Basic4ppc for INSERT rows on the sql table I have no problems.
  3. Nkieto

    Nkieto Member Licensed User

    Ok, I have tried with another SQLite administrator, SQLite Database Browser, GPL off course and editing database with it everything works ok.

    SQLite Database Browser, simple and easy.