Re: how to store special symbols in Oracle

From: Keith Boulton <boulke_at_globalnet.co.nospamuk>
Date: Wed, 26 Aug 1998 07:05:17 GMT
Message-ID: <35e3b001.1098709@news.globalnet.co.uk>

On Wed, 19 Aug 1998 22:56:35 GMT, joelga_at_pebble.org (Joel Garry) wrote:

>by trying helpfully trying to translate them. Is there any way to avoid
>this problem (still using exp/imp)? I understand I could update sys.props$
>set value$='WE8ISO8859P1' where name='NLS_CHARACTERSET'; but I also realize
>this is dangerous and am trying to avoid dangerous. The put it to ascii and
>

One of the oracle manuals says this is what you should do and that it is safe so long as the current characterset is a subset of the new one. I believe us7ascii is a subset of we8iso8859p1 for example. Received on Wed Aug 26 1998 - 02:05:17 CDT