UTF-8 Database

[EdQas]

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

 

[EdQas]

Nobody ?

Hi,
Nobody can help me ?
Ed

 

[Mistrel]

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

 

[Erel]

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?

 

[EdQas]

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

 

[Erel]

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.