Set encoding from within SQL*Plus

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:
Set encoding from within SQL*Plus
Disable BBcode encoding within a latex tag
Advertisements
ModuleNotFoundError: No module named 'sqlite3-plus'
ModuleNotFoundError: No module named 'sqlplus'
ModuleNotFoundError: No module named 'sqlplus_commando'
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
remove duplicates from list in java using 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
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 LightCoral 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 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 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?
nsstring encoding types
How to set the pdfptable as pdf page header when generating the pdf from jsp page. - JSP-Servlet
How to set attachment from browse button to send mails using java mail api
Nest tables within tables
Here is a set of 18 different shades of FireBrick color rangeing from lighter FireBrick color to darker FireBrick color.
Output Encoding - JSP-Servlet
How to store unique values in Java using Set?
How to store unique values in Java using Set?
URL Encoding and URL Decoding
error within servlet
HTTP URL Address Encoding in Java
Setting the default Java character encoding?
ModuleNotFoundError: No module named 'response-encoding'
ModuleNotFoundError: No module named 'target_encoding'
ModuleNotFoundError: No module named 'target_encoding'
ModuleNotFoundError: No module named 'torch-encoding'
ModuleNotFoundError: No module named 'torch-encoding'
ModuleNotFoundError: No module named 'true-encoding'
ModuleNotFoundError: No module named 'categorical-encoding'
ModuleNotFoundError: No module named 'church_encoding'
ModuleNotFoundError: No module named 'emoji-encoding'

Ads