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
19
votes
3 answers

How do I check the NLS_LANG of the client?

I'm working on Windows OS, I know that this setting is stored in the registry. The problem is that the registry path changes from version to version, browsing though that bunch of registry keys is definitly not a good idea. I can get the NLS_LANG of…
Rafael Piccolo
  • 2,328
  • 1
  • 18
  • 29
8
votes
5 answers

Determining the NLS_LANG setting for an existing Oracle database dump file

We were handed a dump file by another team who are gone away for the rest of the year. When we try to import the dump into our own database, we get the following error: IMP-00038: Could not convert to environment character set's handle Upon some…
Ates Goral
  • 137,716
  • 26
  • 137
  • 190
5
votes
4 answers

Oracle specific timestamp format 'DD-MON-RR HH.MI.SSXFF AM'

I have a problem with Oracle 11g specific timestamp format. This is what I have: select to_timestamp('21-OCT-15 08.24.30.000000000 PM','DD-MON-RR HH.MI.SSXFF AM') from dual; Response from database: ORA-01855: AM/A.M. or PM/P.M. required 01855.…
Josip
  • 91
  • 1
  • 1
  • 7
5
votes
3 answers

Validating a day of the week, by name, in Oracle

Given a string representation of a day of the week (i.e. Monday, Mardi, الثلاثاء etc.) and a NLS_DATE_LANGUAGE is there any way of validating that this Day of the Week is valid? Why is this difficult you ask? Well, if this were just English the…
Ben
  • 51,770
  • 36
  • 127
  • 149
5
votes
1 answer

Load text files as clob to database

Having problem loading text files into database as clob. Oracle version: Oracle Database 11g EE Release 11.2.0.2.0 NLS_LANG: RUSSIAN_RUSSIA.CL8MSWIN1251 NLS_CHARACTERSET: AL32UTF8 code to load text files: DECLARE L_BFILE BFILE; L_CLOB …
someuser
  • 83
  • 1
  • 1
  • 6
4
votes
1 answer

ORA-12705: Cannot access NLS data files or invalid environment specified Japanese NLS

I have an error ORA-12705: Cannot access NLS data files or invalid environment specified upon running my program in eclipse. Things I tried so far: I have already tried to rename NLS_LANG subkey in the registry at…
gengencera
  • 426
  • 2
  • 15
3
votes
1 answer

Dojo Globalization and nls keys

i have an DOJO nls key file that have entries like ({ "name":"test", "comma" : ", ", "hello":"Hello", "welcome_msg": this.name+this.comma+this.hello }) I want to have the welcome message be "Hello, test", so basically want to use the name, comma…
user1292547
  • 31
  • 3
3
votes
2 answers

ORA-01855: AM/A.M. or PM/P.M. required

I get the error: ORA-01855: AM/A.M. or PM/P.M. required when I try to execute following query. INSERT INTO TBL(ID,START_DATE) values (123, TO_DATE ('3/13/2012 9:22:00 AM', 'MM/DD/YYYY HH:MI AM')) Where my START_DATE column is of type…
RMN
  • 754
  • 9
  • 25
  • 45
3
votes
1 answer

How to set Oracle NLS_LANG when using JPA

I am using JPA to access an Oracle database which has its encoding set to ISO-8859-1. How do I set NLS_LANG using JPA to receive data in the correct encoding? I suspect it should be set somewhere in the persistence context XML.
Jan Algermissen
  • 4,930
  • 4
  • 26
  • 39
3
votes
1 answer

How do I use OCIEnvNlsCreate() to always get CHAR and NCHAR data back in UTF8 encoding?

Currently I'm using OCIEnvCreate() to create an OCI session handle to communicate with Oracle databases. I'd like to explicitly use UTF8 rather than relying on whatever client locale has been set, and I gather that I need to use OCIEnvNlsCreate() to…
Ted Middleton
  • 6,859
  • 10
  • 51
  • 71
3
votes
1 answer

gibberish on oracle 12.1 db sqlplus errors

I am getting gebbrish on my sqlplus ORA errors. Example: SQL> conn ur@mydb Enter password: ERROR: ORA-01017: ┐┐┐┐┐ ┐┐┐┐┐/┐┐┐┐┐ ┐┐ ┐┐┐┐┐; ┐┐┐┐┐┐┐┐ ┐┐┐┐┐ this is my nls_lang on the registry: AMERICAN_AMERICA.WE8MSWIN1252 I have windows 8 64 bit.…
look4regev
  • 31
  • 3
2
votes
1 answer

cx_Oracle - encoding query result to Raw

EDIT: The following print shows my intended value. (both sys.stdout.encoding and sys.stdin.encoding are 'UTF-8'). Why is the variable value different than its print value? I need to get the raw value into a variable. >>username =…
Joao Figueiredo
  • 3,120
  • 3
  • 31
  • 40
2
votes
0 answers

perl DBI Oracle UTF8 Charset expected

I am trying to understand what is happening here. I am using Perl and DBI::Oracle to connect to my Oracle XE database. I want to get UTF encoded characters as return value on my database query. Unfortunately, my expectation is not met. If you take a…
matthias
  • 21
  • 3
2
votes
1 answer

Oracle database encoding problems

We have two Oracle databases. We read data from database1 in database2 through dblink. In database1 we have NLS_CHARACTERSET = AL32UTF8 and in database2 NLS_CHARACTERSET = EE8ISO8859P2. The problem is that reading data in database2 it's wrong. Some…
F.Lazarescu
  • 1,385
  • 2
  • 16
  • 31
2
votes
0 answers

NLS_LANG = 'AMERICAN_AMERICA.UTF8 issue with Ruby rake

I am using ruby 2.5 and supporting for foreign chars I am using.. NLS_LANG'] ||= 'AMERICAN_AMERICA.UTF8 In ROR application. But facing issue with special chars in file name. Here is the Problem statement. Generating the files using ruby rake…
Sudhir
  • 146
  • 1
  • 4
1
2 3 4 5