Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [nls]

The tag has no usage guidance.

0
votes
0answers
214 views

NLS_ENV is not a valid job attribute Impdp oracle

I'm facing this error while importing database using data pump from 12c to 11g while importing job scheduler ORA-39083: Object type PROCOBJ failed to create with error: ORA-27469: NLS_ENV is ...
0
votes
2answers
1k views

Spool Unicode data in sqlplus to ISO-client without character set conversion

I'm currently facing the following problem: We have an Oracle 11g database with character set AL32UTF8, and an sqlplus-client with NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1. Stored in the database are ...
1
vote
1answer
6k views

how to change nls_language in nls_instance_parameters

Oracle 12c (12.1.0.2.0) database Issue: I wanted to change NLS_LANGUAGE and NLS_TERRITORY in NLS_INSTANCE_PARAMETERS. I know how to change for session, but I wanted to change it for the instance. ...
0
votes
1answer
1k views

ORA-12899: value too large for column COMESFROMTOWN (actual: 50, maximum: 50)

I am importing a csv file into an Oracle database using an external table. The file encoding is UTF-8. The separator is actually ;. The target table definition is identical to the external table ...
1
vote
0answers
964 views

Properly configuring Oracle Charset and NLS parameters

I'm trying to figure out the reason why Oracle SQL Developer shows question marks/rubbish on non-latin symbols. Currently I have 2 DBs on separate severs/instances, one of which works fine, and the ...
3
votes
2answers
1k views

Are there any known problems caused by having NLS_LENGTH_SEMANTICS set to CHAR on an Oracle database?

I've always thought that anyone using a database where NLS_LENGTH_SEMANTICS set to BYTE when using a multi-byte character set needed their heads examined, but recently a customer of ours said that ...
1
vote
2answers
11k views

Oracle systimestamp result differs in db server and client

I am getting some strange output while executing the below command on db server and on client machine connected to same db server. On DB server SQL> select systimestamp from dual; systimestamp ...
1
vote
2answers
339 views

MySQL Duplicate entry for a greek word

I have a column which is unique and when I add Αγάθη and Αγαθή (which are different) it says #1062 - Duplicate entry 'Αγαθή' for key 'word'. My collation is set to utf8_general_ci. Is there any ...
1
vote
2answers
2k views

Specify NLS-Settings during Oracle installation under Windows

Is there an easy way to specify NLS parameters for the database during the installation? We want to install a new database (environment: Windows). For testing purpose we need NLS settings for ...
0
votes
1answer
2k views

ORA-12899 when inserting from sqlplus, but ok with jdbc

Inserting 'ééééé' into a column defined as varchar(5) runs fine from squirrel sql client (jdbc). But doing the same insert from sqlplus fails with ORA-12899 (too long value). NLS_CHARACTERSET is set ...
3
votes
1answer
1k views

NLS_LANG parameter

Is it possible to change NLS_LANG settings on the server after installation Oracle 11.2 XE? (I am not thinking about alter session.) As you know one can not choose db characterset nor nls_lang while ...
1
vote
1answer
549 views

Customizing nls_sort and nls_comp in Oracle

There is different letters for 'KAF' (ک , ك) and 'YA' (ی , ي) in Persian with different unicode codes and same spell. I am using these commands to set Persian sort and comparing in my project ALTER ...
2
votes
1answer
283 views

What's the most appropriate NLS_SORT parameter to cover all/most European languages?

I'm developing an Oracle 11g-based application which is likely to be used by clients in many different countries (mostly European). I want the program to change its NLS_SORT so that it's case ...