Skip to Main Content
Forums

Database Software

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.

NVARCHAR2 in Oracle9i PROBLEM

gansanNov 17 2003 — edited Nov 18 2003
Hi
We have a database in US7ASCII using oracle9i r2 in AIX 5.1. We want to add NVARCHAR2 fields to support NLS progressively.

Scenario 2:With following configuration(v$nls_parameters):
DB character set - US7ASCII
NLS Character set - UTF8

Any insertion of values into the nvarchar2 (USING n LITERALS LIKE N'TEST' and select produces ???.

Scenario 2: The same insertion and selection works if
DB character set - UTF8
NLS Character set - UTF8


The value of NLS_LANG was tried using AMERICAN_AMERICA.UTF8. Looks like NLS_LANG does not really matter in this case. The question is how to make Scenario 1 work? We are not ready to convert the db char set to UTF8 at this stage.

Please help
Thanks in advance

Comments

843844
Hi,
Why you are using <a4j:support> in an a4j:button. you can direcly perform the action and rerender in an a4j:button. 
 <a4j:commandButton  value="submit" action="#{SampleBean.submitButtonAction}" reRender="panelId"
                                           styleClass="buttonStyle"/>
So that the form wont be submitted.
843844
<a4j:commandButton image="#{msgs[\'button.save\']}" alt="#{msgs[\'button.save.alt\']}"
action="#{backing_bean_managechemspecdetails.saveInstruction}" id="savebtn"
rendered="#{backing_bean_managechemspecdetails.m_bShowSaveButton}" onclick="return saveInstruction(this.form)"/>


still refreshed the page when javascript returns true
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 16 2003
Added on Nov 17 2003
#database-key-features, #globalization-support
3 comments
454 views