My Oracle Support Banner

Micro and Degree Symbols Display as Wrong Characters from Command Line SQL*Plus (Doc ID 945448.1)

Last updated on JUNE 28, 2017

Applies to:

SQL*Plus - Version 9.2.0.5 to 11.2.0.4 [Release 9.2 to 11.2]
Generic Windows
Generic Windows

Symptoms

When running a query that returns the special characters (degree symbol and micro symbol),
the incorrect characters are displayed when the query is run from sqlplus.exe. However, the characters
display correctly when run from Sqlplusw.exe, Forms, and SQL Developer.

Steps To Reproduce:

  1. Open a command line prompt on Windows.
  2. Start character-based SQL*Plus using command:   sqlplus.exe
  3. Connect to the database.
  4. Run the query to display the degree and micro characters.
  5. Incorrect characters are displayed, as shown below:

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
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.