Re: Another Character Set Problem

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).