Method, system and computer program product for case and character-encoding insensitive searching of international databases

Abstract

A search string for searching data distributed among various hosts employing different character encoding schemes or having different case-mapping capabilities is entered in a multi-field text string class. The multi-field text string class includes methods for transliterating characters within the original search string based on defined character equivalence tables. When the search string is received at a data host, a comparison is made of the operating system run on the originating data processing system, identified in a sourceVariant field of the multi-field text string class, and the operating system run on the data host, identified in a targetVariant field of the multi-field text string class. If necessary, an appropriate character equivalence table is selected and a variant of the search string is generated by transliteration. The search string variant is then passed to a search engine to search local data, either with or without the original search string, and matches identified are returned as matches for the original search string. Accurate search results are therefore produced despite the presence of different character encoding schemes, such as EBCDIC versus ASCII/Unicode, or operating systems which do not support case mapping.