1

I am able to insert unicode data (mulitybye etc) into varchar2 oracle db column from Oracle SQL developer and its shown correctly. But when the same query is put in sql file and run from command prompt using sqlplus command ,then the inserted characters appears garbled.How to resolve this?

Expecting solution from experts . We will need solution without having to modify the datatype of columns to 'NVARCHAR2' or 'NVARCHAR'.

parshu dhole
  • 11
  • 1
  • Please [edit] the question to include a [MRE] with the: `NLS_CHARACTERSET` settings for your database; the `CREATE TABLE` and `INSERT` statements for your sample data; the output of `SELECT column_name, DUMP(column_name) FROM table_name` for your table/column. – MT0 Jun 09 '23 at 12:19
  • 1
    Seems to be an issue with a terminal codepage – astentx Jun 09 '23 at 12:26

0 Answers0