Japanese Characters Garbled with Spool Output
(Doc ID 2613132.1)
Last updated on OCTOBER 24, 2020
Applies to:
Oracle SQL Developer - Version 19.1 to 19.4Oracle SQLcl - Version 19.1 and later
Information in this document applies to any platform.
Symptoms
Using SQL Developer or SQLcl 19.1 to connect DB 11.2.0.4 or 12c, when run SELECT statement with Japanese characters, the characters show well in standard output within command prompt; however, in the log file of spool output, the characters are all garbled.
For example, spool SELECT statement 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 |