Re: NLS_LANG

From: Gorm Larsen <gorm_larsen_at_jyde.dk>
Date: 2000/01/27
Message-ID: <MPG.12fac20e44d6c97898968c@valhal>#1/1

In article <389191D4.2BB5ABCF_at_caput.com>, morten_at_caput.com says...
> SQL> select * from temp where stuff like LOWER('%Ø%');
>
> no rows selected

It works for me:

SQL> create table test (string varchar2(10));

Tabel er oprettet.

SQL> insert into test (string) values ('køje');

1 række er oprettet.

SQL> select * from test where string like lower('%Ø%');

STRING

---

køje

SQL> select value from v$parameter where name = 'nls_language';

VALUE

---

AMERICAN SQL> select value from v$parameter where name = 'nls_territory';

VALUE

---

AMERICA My workstation is set up with:
DANISH_DENMARK.WE8ISO8859P1
which gives me "Tabel er oprettet." instead of "Table created"

HTH

-- 
Gorm Larsen

Received on Thu Jan 27 2000 - 00:00:00 CST