When you are considering a particular code-page conversion, you want to check an existing database for characters that do not appear in the target code page. This is precisely what is done by the PROUTIL utility with the CONVCHAR CHARSCAN qualifier. It searches for every occurrence of specified characters in every CHARACTER field in the database, using the code page associated with the database. It reports the total number of matched fields, and for each matched field, reports the table name, field name, and record id.
A list of characters. The character list consists of code-page positions separated by commas. The string can include decimal or hexadecimal values for up to ten characters.
Note: For the complete syntax of the PROUTIL utility, see OpenEdge Data Management: Database Administration.
Here are some examples of scanning databases for character conflicts:
You have an ISO8859-1 database called mydb that you are thinking of converting to 1252. To scan this database for the presence of characters not in 1252, run the following command:
You have an IBM437 database called mydb that you are thinking of converting to ISO8859-15. To scan this database for the presence of characters not in ISO8859-15, run the following command:
You have an ISO8859-1 database called mydb that you are thinking of converting to 1252. To scan this database for the presence of characters not in 1252, run the following command: