My Oracle Support Banner

Wrong Foreign Language Characters From SQL*Plus Command-Line on Windows (Doc ID 2755361.1)

Last updated on FEBRUARY 26, 2021

Applies to:

SQL*Plus - Version 12.1.0.2 and later
Generic Windows

Symptoms

On :             SQL*Plus, 12.x version or higher,
Platform:      Microsoft Windows

ACTUAL BEHAVIOR

Query using SQL*Plus Command-Line is not showing the right foreign characters, even though NLS_LANG is set appropriately for the particular language.

It displays the right foreign language data from SQL Developer, but not from SQL*Plus Command-Line.

For Example:
Here is a sample for Turkish language.

  MS-DOS> set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
  MS-DOS> sqlplus <username>/<password>@<db_alias>

  SQL> select <column> from <Turkish_language_table>;

<column>
-------------------------
╟igli

The above is not correct.

However, the result from SQL Developer is correct:

 Çiğli 


Also, the same NLS_LANG setting works for sqlplus on Linux platform. This fails only on Windows.

Changes

First time attempting to use sqlplus on Windows to select foreign language data.

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
References


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