UTF-8 Database

Discussion in 'Questions (Windows Mobile)' started by EdQas, Oct 14, 2007.

  1. EdQas

    EdQas Member Licensed User

    I've used SQL Maestro (7.9) to create a database (in UTF-8 mode), a table and some data.
    Using SQL Maestro, no problem, all my data appear with the good accentuation (like président or lumière), but in basic4ppc with the sql dll, these accentuations disapear !

    How can I specify that my database is an UTF-8 type ?

    Thanks for the help !

    Ed
     
  2. EdQas

    EdQas Member Licensed User

    Nobody ?

    Hi,
    Nobody can help me ?
    Ed
     
  3. Mistrel

    Mistrel Member

    Would it be possible for you to convert your database to unicode? You could try that.
     
  4. Erel

    Erel Administrator Staff Member Licensed User

    Basic4ppc uses UTF-8 encoding for SQL databases.
    Can you upload a small database (make sure it is encoded with UTF-8) that doesn't show correctly?
     
  5. EdQas

    EdQas Member Licensed User

    Here's a small database (.zip) and a copy of a part of the screen of my program (.jpg)
    Thank you for the help. :sign0098:
    Ed
     

    Attached Files:

    Last edited: Oct 16, 2007
  6. Erel

    Erel Administrator Staff Member Licensed User

    There seems to be some difference between the encoding used in SQL Maestro and Basic4ppc.
    What you can do is export the SQL tables to csv files, load the files in Basic4ppc using a Table control and add the tables data to the database with Connection.CreateSQLTable method.
     
Loading...