Multi-lingual applications can be developed on any operating system platform with JDBC using the JDBC Client to access both Unicode and non-Unicode enabled data sources. Internally, Java applications use UTF-16 Unicode encoding for string data. When fetching data, the JDBC Client automatically performs the conversion from the character encoding used by the database to UTF-16.
Similarly, when inserting or updating data in the database, the drivers automatically convert UTF-16 encoding to the character encoding used by the database.
The JDBC API provides mechanisms for retrieving and storing character data encoded as Unicode (UTF-16) or ASCII. Additionally, the Java string object contains methods for converting UTF-16 encoding of string data to or from many popular character encodings.
For information on configuring your server for full Unicode support, refer to the OpenAccess SDK Administrator’s Guide.
