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.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice