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: How can i convert from USASCII7 to WE8ISO8859P1 ?

Re: How can i convert from USASCII7 to WE8ISO8859P1 ?

From: Ulrich Knecht <knecht_at_thales.de>
Date: 2000/06/21
Message-ID: <395087E1.C112B335@thales.de>#1/1

Hello Doug,

        thank you for the hint.

> select value from nls_database_parameters
> where parameter='NLS_CHARACTERSET';

 actually gives US7ASCII. In the meantime I tried some more combinations of NLS_LANG at import/export, still without success. The only hope left seems to be the ALTER DATABASE statement you proposed. But I have to set up a test environment for that to make sure it turns out as expected before exercising it on the "real" database.   Anyhow, I will have to do an import/export afterwards as the database is going to be moved to another disk/tablespace layout.

 Thanks a lot,

        Ulrich Received on Wed Jun 21 2000 - 00:00:00 CDT

Original text of this message

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