Set encoding from within SQL*Plus

Ads
 

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

Ads









Related Tutorials/Questions & Answers:
Set encoding from within SQL*Plus
Disable BBcode encoding within a latex tag
Advertisements
ModuleNotFoundError: No module named 'sqlite3-plus'
Pass cookie from one site to another within the same domain
ModuleNotFoundError: No module named 'sqlplus'
How do I throw a 404 error from within a java servlet?
remove duplicates from list in java using set
ModuleNotFoundError: No module named 'sqlplus_commando'
Display set of names from array
How do I set environment variables from Java?
find jar file name from multiple set of jar files
This is the 18 color set of Almond ranging from light to darker.
This is the 18 color set of DarkGoldenRod ranging from light to darker.
This is the 18 color set of MediumGreen ranging from light to darker.
This is the 18 color set of Rosy Brown ranging from light to darker.
This is the 18 color set of Spring Green ranging from light to darker.
This is the 18 color set of Crimson ranging from light to darker.
This is the 18 color set of LightYellow ranging from light to darker.
This is the 18 color set of MediumPurple ranging from light to darker
This is the 18 color set of SlateGray ranging from light to darker.
This is the 18 color set of LightCoral ranging from light to darker.
This is the 18 color set of Tomato ranging from light to darker.
This is the 26 color set of Blue ranging from light to darker.
This is the 26 color set of Green ranging from light to darker.
How to set the border in header and footer from login page using swings/awt
How to change the value of a variable which is set in jsp (by jstl method) by calling the function from js?
How to set attachment from browse button to send mails using java mail api
nsstring encoding types
Output Encoding - JSP-Servlet
Here is a set of 18 different shades of FireBrick color rangeing from lighter FireBrick color to darker FireBrick color.
How to store unique values in Java using Set?

Ads