Re: How can i convert from USASCII7 to WE8ISO8859P1 ?

Since the customer is going to 8i, what about upgrading the database as is from 8.0 to 8i, then using the following command to change the character set:

   ALTER DATABASE [<db_name>] CHARACTER SET <new_character_set>;

However, it sounds pretty curious to me that the database character set is US7ASCII, yet extended ASCII characters are being stored and retrieved correctly. What does this query return?

   select value from nls_database_parameters    where parameter='NLS_CHARACTERSET';

Are you sure the data is not coming through a dblink or is stored in a NCHAR column?

Regards, Doug.

Ulrich Knecht <knecht_at_thales.de> wrote:
>Hello,
> I have a question concerning character set conversion: Our
 customer
>uses an oracle 8.0.5 Database (on Linux) using USASCII7
 character set.
>He wants to migrate to oracle 8i (also on Linux) using iso
 character set
>(WE8ISO8859P1). The original data contains german umlauts (=E4,
 =F6, =FC,=
> =DF)
>which are being displayed correctly although they are not
 contained in 7
>bit ASCII (Don't ask me why, but it works). =
>
> How can I migrate the data in a way that what is, e.g. an
 "=E4"
>(a-umlaut) in the old data base still appears as an "=E4" in the
 new one?=
>
> I made the following attempts, all of which didn't have the
 required
>result:
>
> - export without NLS_LANG set (which should default to US
 ASCII 7
>bit), import with =
>
> NLS_LANG=3DGERMAN_GERMANY.WE8ISO8859P1
>
> - export / import without NLS_LANG set
>
> - export / import with

 NLS_LANG=3DNLS_LANG=3DGERMAN_GERMANY.WE8ISO8859P=
>1 =
>
>
>I'd be very thankfull if anyone could help me solve this
 problem.
>
> Ulrich
>
>

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Jun 20 2000 - 00:00:00 CDT