My Oracle Support Banner

Gateway and NLS - Foreign Data Store Demo Table with Foreign Character Strings (Doc ID 1453149.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Database Gateway for SQL Server - Version 11.1.0.6 and later
Oracle Database Gateway for DRDA - Version 11.2.0.1 and later
Oracle Database Gateway for Informix - Version 11.1.0.6 and later
Oracle Database Gateway for Sybase - Version 11.1.0.6 and later
Information in this document applies to any platform.

Purpose

 This note is part of multiple notes describing the NLS settings for Oracle Database Gateways connecting to foreign databases.

Scope

A sample table for many foreign databases that can be used to diagnose GATEWAY and  NLS issues.

Details

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
Scope
Details
  DB2 create table using vargraphic data type:
 other foreign databases using nvarchar like MySQL, MS SQL Server, Sybase etc:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.