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

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.

2. The method of claim 1 , wherein the predefined assessment command produces a list of lines and columns that include unique characters that are not recognized by the codepage of the database to which the characters have been inserted.

3. A computer program product embodied on a non-transitory computer readable medium storing computer code executable by a processor to perform 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.

4. A system comprising:

a memory system; and

one or more processing cores coupled to the memory system and that are each configured to perform 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.