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 ?
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.