System, method, and computer program for automatically converting characters from an ISO character set to a UTF8 character set in a database

摘要

A system, method, and computer program product are provided where non-convertible lines in a database that that are comprised of characters that are not recognized by a codepage of the database are identified as result of a predefined assessment and are then exported from the database. The exported non-convertible lines are automatically converted to convertible lines by using a mapping table, and the non-convertible lines are deleted from the database. After deleting the non-convertible lines, a predefined conversion command is executed on the database, thereby converting all characters of the database from an ISO format to a UTF8 format, and then the convertible lines are imported into the database utilizing a predefined import utility that automatically converts all characters of the convertible lines, once inserted into the database, from the ISO format to the UTF8 format.

主权项

1. A method, comprising:
executing a predefined assessment command on a database to identify non-convertible lines in the database that are comprised of characters that are not recognized by a codepage of the database; exporting, from the database, the non-convertible lines identified as a result of the execution of the predefined assessment command; automatically converting the exported non-convertible lines to convertible lines comprising characters that are recognized by the codepage of the database by using a mapping table that maps the characters of the exported non-convertible lines to the characters that are recognized by the codepage of the database; deleting the non-convertible lines from the database; after deleting the non-convertible lines from the database, repeating execution of the predefined assessment command on the database, thereby verifying that all characters of the database are recognized by the codepage of the database; responsive to the verification that all the characters of the database are recognized by the codepage of the database, executing a predefined conversion command on the database, thereby converting all characters of the database from an International Organization for Standardization (ISO) format to a UTF8 format; and after executing the predefined conversion command, inserting the convertible lines into the database utilizing a predefined import utility that automatically converts all characters of the convertible lines, once inserted into the database, from the ISO format to the UTF8 format.