Forum Stats

  • 3,733,838 Users
  • 2,246,829 Discussions
  • 7,856,890 Comments

Discussions

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

User_XLDQS
User_XLDQS Member Posts: 1 Green Ribbon

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;

/

Tagged:

Answers

Sign In or Register to comment.