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
Pass cookie from one site to another within the same domain
How do I throw a 404 error from within a java servlet?
Pick random element from Set
Display set of names from array
How do I set environment variables from Java?
how to set values from parent page to iframe in javascript
find jar file name from multiple set of jar files
nsstring encoding types
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.
Output Encoding - JSP-Servlet
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.
URL Encoding and URL Decoding
How to set the border in header and footer from login page using swings/awt
how to set the image and address in single row when genearting pdf fil from jsp - JSP-Servlet
How to change the value of a variable which is set in jsp (by jstl method) by calling the function from js?
Nest tables within tables
HTTP URL Address Encoding in Java
Setting the default Java character encoding?

Ads