Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: asking for help about NLS

Re: asking for help about NLS

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/09/01
Message-ID: <340AACFC.2E39@gatwick.geco-prakla.slb.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US