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

    公开(公告)号:US09626417B1

    公开(公告)日:2017-04-18

    申请号:US14259060

    申请日:2014-04-22

    Inventor: David Sofer

    CPC classification number: G06F17/30569

    Abstract: 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.

Patent Agency Ranking