Re: Another Character Set Problem

This command is NOT supported by Oracle and Oracle would not guarantee that your data is not corrupted -- particularly if you have not run the character-set-scanner to verify it. Hemant

At 05:33 AM 17-09-02 -0800, you wrote:
>To change the character set to another that is not recognized as a superset
>use:
>Alter database <db-name> character set INTERNAL_USE <new_character_set>
>
>This parameter is active for oracle 8.1 and above.
>
>Yechiel Adar
>Mehish
>----- Original Message -----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Sent: Thursday, September 12, 2002 3:18 PM
>
>
> > We are currently having a character set problem. We have a
> > third-party product that is used for on-line courses (Prometheus from
> > Blackboard, Inc.). The character set that the instance was created with
> > was US7ASCII. The vendor says it should be WE8ISO8859P1, but we need to
> > support Chinese and Japanese characters. I contacted Oracle support,
> > and was told that the specified character set would not support those
> > characters, but that I should use UTF8. I altered the instance to use
> > UTF8 and ran into a CLOB problem. We installed patchset 4 (so we are
> > now 8.1.7.4.0 on Sun Solaris 2.8) and that problem went away. However,
> > none of the CLOB data is rendered properly in the application and I
> > don't have a tool that allows me to see it directly out of the database.
> >
> > I am tempted to try to change the character set to WE8ISO8859P1, as
> > the vendor requested, with the hope that any deficiencies in that
> > character set have been handled by their product. At this point, can I
> > change the instance from UTF8 to WE8ISO8859P1? I do have a tar open on
> > this issue and will be asking the same question there, but I'm hoping
> > I'll get a response here faster (ok, I'm expecting that I will).
> >
> > Thank you.
> >
> > --
> > Scott Canaan (srcdco_at_rit.edu)
> > (585) 475-7886
> > "Life is like a sewer, what you get out of it depends on what you put
> > into it." - Tom Lehrer.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Scott Canaan
> > INET: srcdco_at_ritvax.rit.edu
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).