ECDA Option for Oracle has multiple settings that correspond to the character set and language setting, which can be set in many ways. However, you must designate the character set settings that is consistent with the charset settings.If the configuration parameter charset is set to Sybase iso_1, the mapping coded in the “charsets” stanza must be mapped to Oracle’s equivalent character set, which is we8iso8859p1. In addition, this setting must also be reflected in the “languages” stanza by including the we8iso8859p1 in the Oracle charset setting. If these are not set consistently and a character is used that is contained in either the Sybase or Oracle character set and not in the other, you may receive an “ORA-00911: invalid character” message.ECDA Option for Oracle converts the incoming client characters to the charset setting, which should match that of the Oracle setting. When characters are returned to the ECDA Option for Oracle client, they are then converted back to the character set setting of the client.The language setting corresponds to the language in which the local ECDA Option for Oracle error messages are returned. The setting for Oracle Language and Territory coded in the languages stanza is the language in which the Oracle defined error messages will be sent back to the client. All attempts must be made to make sure the language settings match.
