Re: NLS_LANG

Great, thanks. Just one problem, it doesn't work with stuff I want to be case insensitive, eg:

SQL> create table temp (stuff varchar2(20));

Table created.

SQL> insert into temp (stuff) values ('kųje');

1 row created.

SQL> select * from temp where stuff like LOWER('%K%');

STUFF

SQL> select * from temp where stuff like LOWER('%Ų%');

no rows selected

SQL> select 'drat' from dual;

...Morten

Gorm Larsen wrote:
>
> In article <38900FBB.949AF5D1_at_caput.com>, morten_at_caput.com says...
> > Are the other ways to set NLS_LANG than by setting
> > an environment variable? First, I had
> > NLS_LANG=Danish.WE8ISO8859P1 which should allow
>
> Take a look at the documentation for NLS* parameters.
>
> Put:
> NLS_LANGUAGE = Danish
> NLS_TERRITORY = Denmark
> NLS_DATE_LANGUAGE = Danish
> NLS_DATE_FORMAT = 'DD/MM-YYYY'
> in your Init????.ora file and restart the database
> or use Alter session set nls_???? = Danish
>
> --
> Gorm Larsen

--

Morten Primdahl		Caput ApS	Tel +45 33 12 24 42		
morten_at_caput.com	Nygade 6	Fax +45 33 91 24 42
http://www.caput.com	DK-1164 Kbh K