NLS_LANG is a client side environment variable used to define language, territory and character set properties and to specify the locale behavior.
Questions tagged [nls-lang]
64 questions
0
votes
1 answer
NLS setting for multilanguages
My current application is running with NLS_lang as American.america on Oracle forms. We are planning make this application available on multilanguage. we are in the process of the modifying the code to handle application labels, prompts,hint,…
user3183775
- 1
- 2
0
votes
0 answers
Insert the to_timestamp and NLS_LANGUAGE through unix shell
I've got this timestamp field:
if [ "${arr[1]}" != "NUMBER" ];
then
fieldtmst=`echo $var |
awk 'BEGIN { f="'"'"'" }
{
split($0,x,/@#/);
printf "%s\n", f x[1] f
…
Atlas91
- 5,754
- 17
- 69
- 141
-1
votes
1 answer
Oracle REGEXP_LIKE ignore CASE SENSITIVITY
We are trying the following request in Oracle Database 19.3 and the result is ever like the case sensitivity was ignores.
select 1 from dual where regexp_like('CHIEN', '[a-z]+', 'c');
And the result of the request is
1
Even with:
ALTER SESSION SET…
Chris
- 9
- 2
-3
votes
1 answer
Some of the rows not displaying non-english characters in Oracle
The character set of the db is
"WE8MSWIN1252"
and I am inserting the rows through a bat file where I set "NLS_LANG" to
".WE8MSWIN1252"
. At the end of the insertions, some of the rows in SQL Developer display a certain character while some…
Sammy
- 885
- 3
- 13
- 32