I believe AL32UTF-8 is a superset of UTF-8 not a subset. Here is some info from the Oracle Content Services Administrator's Guide for 10g (10.1.2)
-------------------------- If your Oracle Content Services instance will contain multilingual documents, AL32UTF-8 is the recommended database character set. AL32UTF-8 supports characters defined in the Unicode standard. The Unicode standard solves the problem of many different languages in the same application or database. Unicode is a single, global character set which contains all major living scripts and conforms to international standards. Unicode provides a unique code value for every character, regardless of the platform, program, or language. AL32UTF-8 is the 8-bit encoding of Unicode. It is a variable-width encoding and a strict superset of ASCII. One Unicode character can be 1 byte, 2 bytes, 3 bytes, or 4 bytes in AL32UTF-8 encoding. Characters from the European scripts are represented in either 1 or 2 bytes. Characters from most Asian scripts are represented in 3 bytes. Supplementary characters are represented in 4 bytes. By using a Unicode-based file system, document content and metadata of different languages can be shared by users with different language preferences in one system. -------------------------- Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang Sent: Wednesday, September 06, 2006 10:36 AM To: [email protected] Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9 Hello, All! I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues: 1. If we don't get ARSystem table space created prior to the installation, we get the following error: "An unknown Oracle error has been detected. Please resolve this error and re-try the installation. Refer to /tmp/arDBErrorLog for the Oracle error information." I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details. After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? If you didn't create ARSystem table first, what's the default table space for ARAdmin? 2. We got the following after we chose to use UNICODE: "Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set. If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set. Do you want to use the UNICODE character set? [n] y *** Your current locale (C) is not Unicode and you are asking for *** a Unicode install. Please adjust your LANG and LC_ALL variables. *** You can either change your UNICODE option or abort the *** installation to adjust your LANG and LC_ALL variables. Do you want to abort the installation? [n]" I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation. I discussed this with my DBA and he sent me the database creation SQL statement as following: CREATE DATABASE "rmdytst1" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8 Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation? Thanks in advance for your help. Eric Zhang Entergy Services, Inc. 501-377-5815 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
