Set encoding from within SQL*Plus

Hi,

In Oracle server I am running sql query from sqlplus which is adding Spanish data. But data is converted wrongly due to UTF conversion.

How to resolve this.

Thanks

View Answers

November 28, 2017 at 3:06 AM

Hi,

Run following query in your sql at first line:

alter session set NLS_LANGUAGE=SPANISH;

This will resolve issue.

Thanks









Related Tutorials/Questions & Answers:
Advertisements

Questions by Category