Re: convert CL8WIN1251 to UTF8

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 05 Aug 2002 22:32:12 +0200
Message-ID: <i2otkukd3uphh5uai4rktuau26af34f47k@4ax.com>

On Mon, 05 Aug 2002 15:21:43 -0400, JC <jeffc_at_sympatico.ca> wrote:

>Sybrand Bakker wrote:
>
>> Not true, for 8.0 and higher. You CAN change the characterset provided
>> the new characterset is an exact superset of the old characterset.
>> Apparently UTF8 isn't a superset of CL8WIN1251.
>> In that case the export/import route is the only solution and no
>> 'forcing of the database' is possible.
>
>In the Oracle 8i Certified Professional book it states the opposite on page
>635. Now this book has been proven to be wrong before. I went into the
>exam thinking that the NLS values couldn't be changed. I could be wrong
>and if you have any sources that prove you can please let me know.

How about the manual called 'Sql reference' under 'Alter database' If that's wrong we would have known in the meantime, don't you think. Anyway, I've changed databases' charactersets several times using alter database.
There is a note up on Metalink with the exact details (job_queue_processes must be 0, aq_tm_processes too)

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Aug 05 2002 - 15:32:12 CDT