Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Database support for unicode

504552Jan 20 2009 — edited Jan 21 2009
Hello, I am in the process uf upgrading database installation scripts so they will support Unicode. I just want to clarify that by changing the Character set to say for example AL32UTF8 and the National Character Set to UTF8 the database will then be able to support Unicode. Do I need to also change all the VARCHAR2 and CHAR2 data types to NVARCHAR2 and CHAR2? When changing the character sets do the database then default to bytes instead of characters for multibyte character storage? Thank you.

-- David

Comments

Forms6i uses Oracle 8.0.6 client libraries. MetaLink Note 207303.1 lists supported client/server configurations, and the last database version supported with those libraries is Oracle 9.2. The only exception is made for e-Business Suite (Oracle Applications). Therefore, you configuration is not supported.

Anyway, Oracle 8.0.6 does not support AL32UTF8 well. You should select UTF8 as the database character set (not national character set!). You need to select a check box on DBCA interface (possibly unavailable in fast/default installation path) which allows you to see non-recommended character sets.


-- Sergiusz
1 person found this helpful
Abk
Thanks Sergiusz.

Here i am able to connect forms 6i with 11g Database without any issue.
only problem is connect with AL32UTF8 DB.

Doc 207303.1 speaks about only network connectivity. can you support your statement +"Anyway, Oracle 8.0.6 does not support AL32UTF8 well"+ providing any document.

Thanks & Regards

Abk
MetaLink note 237593.1



-- Sergiusz
Abk
Thank you Sergiusz.

Your documents are very useful


--
Abk
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 18 2009
Added on Jan 20 2009
#general-database-discussions
14 comments
1,070 views