My Oracle Support Banner

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.4
Oracle SQLcl - Version 19.1 and later
Information in this document applies to any platform.


Using SQL Developer or SQLcl 19.1 to connect DB 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:



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

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