Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to compile a UTF-8 .sql file that contains Unicode characters

ToddBarryNov 10 2022

We have a UTF-8 file containing the code for a PL/SQL package, and the code contains some diacritical Unicode characters.
When compiling with SQLcl, the package compiles successfully but those characters get corrupted within the data dictionary (and the code throws an exception when run because the corruption makes the size of a variable too large).
How can this file compile correctly (no error, no corruption) with SQLcl?
Here's an example of the code in the .sql file:
CSF_A constant varchar2(6) := 'ÀÁÂÃÄÅ';

Comments
Post Details
Added on Nov 10 2022
1 comment
760 views