In DataFlex, OEM tables are only supported for backward compatibility. When migrating to DataFlex 2021 or higher, OEM tables should be converted to ANSI/Unicode tables.
To assist with that, DataFlex includes a conversion wizard in Database Builder: the OEM to ANSI Conversion Wizard.
The wizard can be used to convert to ANSI any SQL table set to store OEM characters. It will detect all OEM tables in a workspace that subsequently can be selected to be converted to ANSI.
The OEM to ANSI Conversion Wizard will irreversibly change your data. Make sure you have proper backup of your entire database and all your INT files before running the conversion.
The wizard will perform the following tasks on OEM tables selected for conversion:
Note that this can be a lengthy process, even when a table contains only ASCII (<128) data and no actual conversion is needed.
The wizard will irreversibly change your data. Make sure you have proper backup of your entire database before running the wizard.
To start the wizard, you will need to open Database Builder for the workspace you wish to have tables analyzed and converted from OEM to ANSI and then select the wizard.
Continue through the wizard and select the tables to be converted from OEM to ANSI. The wizard will do the rest.
Notice that only OEM tables will be selectable:
At the end of the process, the wizard will display a status screen like the one below:
You may review details of the conversion by clicking Show log file button to open the log file generated by the wizard.
Once the wizard successfully converts the selected tables, make sure to test your application accessing the converted tables.
Table Character Format in DataFlex