International Business Machines Corporation
REDUCING CHARACTER SET CONVERSION

Abstract:

A computer-implemented method reduces the number of character set conversions in a distributed data virtualization system. The method includes receiving, from a first application, a first request for a set of data, including a requested codepage, stored in a first data source of a plurality of data sources. The method includes obtaining, by a connector, from the first data source, a first codepage associated with the first data source, which identifies a character set associated with the set of data. The method also includes adding a virtual coded character set identifier (VCCSID) in a first catalog entry of a catalog, wherein the first VCCSID is added to a nickname column of the catalog. The method includes obtaining and sending the set of data to the data application while allowing maximum of one codepage conversion.