ASE unichar and univarchar datatypes are supported with Oracle 9i databases. Oracle errors will result if these datatypes are used with previous versions of Oracle.
To support the ASE unichar and univarchar datatypes the DirectConnect for Oracle must be configured to use the utf8 charset for both Sybase and Oracle as follows:
The configuration option charset = must be set to utf8.
The Sybase language mapping in the [languages] section of the configuration file must specify utf8 as the Oracle charset.
The following example shows the configuration values needed to support Unicode for a server named “unidco” which uses us_english as its language.
[unidco] charset = utf8 language = us_english . . . [languages] ; ; Maps a Sybase language to an Oracle Language, Territory, and Charset ; us_english american america utf8
