Scott,
You can only use the alter database command to move from one character set
that is a strict superset of your current character set. You can find
lists of superset relationships on Metalink. Search on something like
character set conversion and superset or UTF8 and WE8ISO8859P1.
You probably realize it but if you are going to use the alter database
command to do the conversion, you need to run the character set scan
utility csscan first and fix any data exceptions before you actually
perform the conversion. Metalink has a couple of good notes such as
123670.1 and 66320.1 on exactly how to do this.
Cherie Machler
Oracle DBA
Gelco Information Network
Scott Canaan
<srcdco@ritvax To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
.rit.edu> cc:
Sent by: Subject: Another Character Set Problem
[EMAIL PROTECTED]
om
09/12/02 08:18
AM
Please respond
to ORACLE-L
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 ([EMAIL PROTECTED])
(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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
