Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can you specify the output character set for sqlcl ?

Fpons-OracleJan 10 2022

Unlike SQL*Plus, sqlcl does not follow NLS_LANG. Suppose you want to select a string from a database in AL32UTF8 and display it in, say, a Windows 10 Command Prompt window using WE8PC850 as character set. How do you tell the Oracle Net layer within sqlcl to adapt to gthe client character set ?

Comments

Post Details

Added on Jan 10 2022
1 comment
2,395 views