Set encoding from within SQL*Plus

 
 

Share on Google+Share on Google+

Java Coder
Set encoding from within SQL*Plus
1 Answer(s)      17 days ago
Posted in : SQL
Ads

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

Ads
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


Ads









Related Tutorials/Questions & Answers:
Advertisements

Ads

 
Advertisement null

Ads