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!

SqlCl 20.04: Update statement with Chinese characters inserts invalid data.

User_XLDQSApr 27 2021

Hi,
I have an update statment in a file with encoding UTF 8 w/o BOM which when run through SqlCl inserts incorrect characters in the database. If the contents are run directly from Sql Developer the script works fine.
Script:
Update TAB_TXT
SET
NME_COL = '统',
...
Where DATA_ID = 61;
COMMIT;
/

Comments
Post Details
Added on Apr 27 2021
1 comment
237 views