Re: asking for help about NLS

The code you need is;

update sys.props$
set value$ = upper('&1') -- where &1 is the new character set
where name = 'NLS_CHARACTERSET';

Note, that this will only cause future characters to be stored using the new characterset, any existing data will still be in the old characterset and may need changing where differences arise.

Hope this helps.

Ian Received on Mon Sep 01 1997 - 00:00:00 CDT