My Oracle Support Banner

Multibyte Column Names Are Garbled When Showing a Table Using DESC Command (Doc ID 3062272.1)

Last updated on DECEMBER 06, 2024

Applies to:

SQL*Plus - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

When using DESC command to display a table with multi-byte column names, you see some additional characters, and a part of them are garbled.

If the linesize is default(80), then columns which have names over 14 multi-byte characters become wrong results.

Note: In this example, please assume that X is a multi-byte character and G is a garbled character.

For Example:

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.