I have to migrate a legacy application written in Clipper 5 using DBF/CDX database (probably FoxPro 2.5). The new app will use firebird 4. The migration of the data is working correctly except for some especial characters (the language is Brazilian Portuguese). For instance:
“Praça ” becomes “Pra?a”. The same happens with á, â, ã and other special etc.
The connection string is:

Dim conn = New OleDbConnection("Provider=vfpoledb;Extended Properties=""text;HDR=Yes;FMT=Delimited;'CharacterSet=65001'"";Data Source=<my data source>")

I have tried some character sets (don’t know all the possible options), and also the vb.net Enconding class to try to get it right. Nothing has worked so far.

All of this to avoid writing a procedure to go through each field of each table and converting data manually.

Thanks for your help.