Questions tagged [nls]
The nls tag has no usage guidance.
12
questions
1
vote
2
answers
5k
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 ...
- 11
1
vote
1
answer
15k
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. ...
- 131
0
votes
1
answer
2k
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 ...
- 133
2
votes
0
answers
2k
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 ...
- 121
3
votes
2
answers
2k
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 ...
- 163
1
vote
2
answers
14k
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
...
- 295
1
vote
2
answers
525
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 ...
- 113
1
vote
2
answers
3k
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 ...
- 11
0
votes
1
answer
3k
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 ...
- 442
3
votes
1
answer
2k
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 ...
- 31
1
vote
1
answer
646
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 ...
- 137
2
votes
1
answer
340
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 ...
- 433