My Oracle Support Banner

Language of SQL*Loader Results Title can not be Changed by NLS_LANG Before 12c (Doc ID 2172122.1)

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Language of SQL*Loader Results Title can not be changed by NLS_LANG before 12c.

- In pre-12c Oracle releases, the sqlldr results title from the log file is displayed in English, even if NLS_LANG is set to Non-English such as GERMAN_GERMANY.WE8MSWIN1252 or JAPANESE_JAPAN.JA16SJISTILDE.

Example:
------------
> echo $NLS_LANG
JAPANESE_JAPAN.JA16SJISTILDE

Pre-12c Sqlldr log file shows:

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
N1 FIRST * , O(")CHARACTER
V1 NEXT * , O(")CHARACTER

- From 12c, Sql*Loader supports Multi-Language characters when NLS_LANG is set to Non-English. e.g Japanese for the example above.

12c Sqlldr log file shows:

列名 位置 長さ 用語暗号化データ型
------------------------------ ---------- ----- ---- ---- ---------------------
N1 FIRST * , O(")CHARACTER
V1 NEXT * , O(")CHARACTER

 

Changes

 None.

Cause

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
Symptoms
Changes
Cause
Solution


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