Stack Overflow
Stack Overflow

Questions tagged [nls-lang]

NLS_LANG is a client side environment variable used to define language, territory and character set properties and to specify the locale behavior.

64 questions
2
votes
0 answers

Oracle: Incorrect language compiled in PLSQL from sqlplus

I have some danish names in my plsql proc. Whenever i try to compile from TOAD, the danish words get compile in correctly in my database. But whenever i try to com pile from sqlplus, the danish special characters gets scrammbled and eg Ø comes as…
saurabh.manjrekar
  • 33
  • 5
2
votes
2 answers

Incorrect Special Character Handling in Informatica Powercenter 9.1

I am currently working on a project in my organisation where we are migrating Informatica Powercenter in our application from v8.1 to v9.1. Informatica PC is loading data from datafiles but is not able to maintain certain special characters present…
Yavnica Saini
  • 33
  • 1
  • 1
  • 8
2
votes
1 answer

oracle date format issue

We use Oracle 10.2.0.4.0 database, oracle form builder and report builder for creating forms and reports. Now the problem is in our production database nls_date_format is dd-mon-rr format. When developer create form in developer suit they give…
Jayesh
  • 46
  • 9
2
votes
1 answer

Why Oracle displays ??? for special characters like åäö

Some time ago my PL/SQL stopped showing characters åäö. I've tried reinstalling oracle_home_11g, PL/SQL cleaned the registry but the problem remains. Anyone know why?
President Camacho
  • 1,860
  • 6
  • 27
  • 44
1
vote
0 answers

Can I use multiple NLS_LANG in same sql loader?

I have a situation where my Oracle sql loader has to support 4 character sets. The loader script is common and loads files from multiple country sources, hence the requirement. At the moment, the value of a field coming from file is…
Raj
  • 11
  • 1
1
vote
0 answers

How to fix reversed arabic characters mixed with english in pl / SQL?

I have an oracle database and I have stored print message inside it contains Arabic and English characters in the same field just like عبر الرابط : (https\www.google.com) Seeking your help to split the Arabic characters from English ones to reverse…
Eman mohamed
  • 37
  • 4
1
vote
2 answers

Oracle Client_charset

I am using 19c client and my database's NLS parameters like these: Also my clients specs are: While (Windows 10 x64) I am using sqplus, I get this(you can see my NLS_LANG environment variable on the top of command line): My 19c client home…
Umut TEKİN
  • 856
  • 1
  • 9
  • 19
1
vote
1 answer

Oracle character encoding - specific symbols displayed incorrectly

Web-browser displays specific Norwegian symbols incorrectly. configuration of DB: NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT…
sergionni
  • 13,290
  • 42
  • 132
  • 189
1
vote
1 answer

ORACLE - NLS_LANG, CHARSET, SPECIAL CHARS

I have the following problem on WINDOWS (Italian): my NLS_LANG parameter is: ITALIAN_ITALY.UTF8 i want to execute the following query: INSERT INTO SCHEMA.MY_TABLE("NAME") VALUES('ò'); Doing it by using command line (pure sqlplus) stores invalid…
Lazarus
  • 147
  • 13
1
vote
0 answers

Oracle CLOB to XMLTYPE Errors

We are running an older Oracle Server, 10.1.0.5... yes, we will upgrade soon. Some relevant NLS Settings are as follows... NLS_CHARACTERSET IS 'US7ASCII' NLS_LENGTH_SEMANTICS IS 'BYTE' Onto the question... We have well formed XML stored in CLOB…
sse
  • 987
  • 1
  • 11
  • 30
1
vote
1 answer

NLS: custom languages handler in single html view

I have some tables to display amounts of money in dollars, currency symbol position. The thing is that I want to show different representations of currency based on the language selection, French or English. So, I want to be able to substitute html…
Jenny
  • 45
  • 3
1
vote
1 answer

NLS_DATE_LANGUAGE issue with a few languages

I have written the following code to fetch a date based on the users NLS_LANGUAGE variable. I am writing this code in BI Publisher inbuilt in Oracle Fusion but i doubt that it will matter. I have seen that it works fine for AMERICAN, SPANISH, etc…
prince
  • 854
  • 2
  • 9
  • 36
1
vote
2 answers

Oracle 10g NLS Parameters

Could people please let me know if there are any issues with setting Oracle 10g NLS Parameters at database level, specifically the NLS_TERRITORY to the country I am in together with setting the timezone to UTC. Will there be any conflicts b/c as the…
tonyf
  • 34,479
  • 49
  • 157
  • 246
1
vote
0 answers

Escape sequence not working in oracle 10g driver

I am connecting oracle 11g database through C code. I am using oracle 10g driver for DB connection. Query failed with error code 1461. When I try to insert string : 'I am in ' Mumbai ' ' ===> It failed. I tried: 'I am in 'Mumbai' ' ===>It was…
Charuta Save
  • 83
  • 5
1
vote
2 answers

"¿" (inverted question mark) character in oracle

I found "¿" character (inverted question mark) in the database tables in place of single quote (') character. Can any one let me know how i can avoid this character from the table. There are many rows which contains the text with this character but…
Mohit Tamrakar
  • 395
  • 1
  • 4
  • 7
1
2
3 4 5