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 character set INTERNAL_USE > >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).
Re: Another Character Set Problem
To change the character set to another that is not recognized as a superset use: Alter database character set INTERNAL_USE 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).
RE: Another Character Set Problem
The utility is called csscan for character set scan. It runs at the unix prompt with additional parameters (some optional and some not) much as export or import would. Before you use it the first time, you need to run csminst.sql from $ORACLE_HOME/rdbms/admin to set up the work tables, etc. Cherie Machler Oracle DBA Gelco Information Network Ron/Sarah YountTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Another Character Set Problem Sent by: [EMAIL PROTECTED] om 09/12/02 09:23 PM Please respond to ORACLE-L Scott, 1) I have to agree with Oracle's statement that you need to have a UTF8 database to handle Chinese and Japanese characters. These characters require multi-byte encoding to be stored and therefore a UTF8 database is the way to go. 2) I am not sure "where" the Chinese and Japanese characters are stored, but it is quite likely that you will fail to store them correctly in a P1 database. 3) You can run a utility... Name escapes me that will check your contents to see if changing character sets will result in a loss of current data (this is an oracle supplied utility). 4) Alternately, you could export the contents of the database and import them into a new WE...P1 database. Make sure that you review metalink docs on setting your NLS_LANG correctly for such imports and exports. HTH, -Ron- -Original Message- Canaan Sent: Thursday, September 12, 2002 8:18 AM To: Multiple recipients of list 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 infor
RE: Another Character Set Problem
Scott, 1) I have to agree with Oracle's statement that you need to have a UTF8 database to handle Chinese and Japanese characters. These characters require multi-byte encoding to be stored and therefore a UTF8 database is the way to go. 2) I am not sure "where" the Chinese and Japanese characters are stored, but it is quite likely that you will fail to store them correctly in a P1 database. 3) You can run a utility... Name escapes me that will check your contents to see if changing character sets will result in a loss of current data (this is an oracle supplied utility). 4) Alternately, you could export the contents of the database and import them into a new WE...P1 database. Make sure that you review metalink docs on setting your NLS_LANG correctly for such imports and exports. HTH, -Ron- -Original Message- Canaan Sent: Thursday, September 12, 2002 8:18 AM To: Multiple recipients of list 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: Ron/Sarah Yount 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).
Re: Another Character Set Problem
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 .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).
