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