How do I import special characters from foxpro fields into firebird in vb.net?
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 characters etc.
The overall approach is:
How do I import special characteres from foxpro fields into firebird in vb.net?
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: