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 <[EMAIL PROTECTED]> >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 ([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: Yechiel Adar > INET: [EMAIL PROTECTED] > >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: [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). 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: [EMAIL PROTECTED] 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: [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).