RDBPROD: Configuration example to use accents between Oracle Rdbms and Oracle Rdb through SQLNET (Doc ID 277616.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1.5 and later
Information in this document applies to any platform.



Goal

Provide a way to enter data in an Oracle Rdb database from Oracle clients running on different platforms. This data can contain characters with accents.

The notion of character set (as it exists in Oracle) is not the same in Oracle Rdb.

OCI Services for Rdb will display the character set in Oracle Rdb as US7ASCII.

SQL> select * from nls_database_parameters;

PARAMETER VALUE
------------------------------ ------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_DATE_LANGUAGE AMERICAN
NLS_DATE_FORMAT DD-MON-RR
NLS_CHARACTERSET US7ASCII
NLS_SORT BINARY
NLS_CALENDAR GREGORIAN
NLS_NCHAR_CHARACTERSET US7ASCII

It is important to verify each type of client (Windows, OpenVMS, UNIX...) to ensure the characters are correctly translated to Rdb and can be read by all clients.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms