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.

Globalization - Unicode support with Alter Datatype

439265Mar 3 2005 — edited Mar 3 2005
We have an database with NLS_Characterset as US7ASCII and National Language Charaterset as AL16UTF16. We altered column on one of the table to be NVARCHAR2(300). With client settings AMERICAN_AMERICA.UTF8, I am not able to insert unicode to the database.

If I create another database with NLS_Characterset as UTF8, my same application (VB - OLEDB, through the exact same client settings) can successfully insert Unicode data to the table.

Does this mean that in order to support Unicode data on the database the database NLS_characterset ***CANNOT*** be US7ASCII. Looking at the oracle documentation it appeared that as long as the NLS_NCHAR_CHARACTERSET is set properly, you should be able to store Unicode data if the column is defined as NVARCHAR2.

Comments

495335
I've found some information that looks helpful, in the form of a blog entry found at:

http://forms.pjc.bean.over-blog.com/article-3234108.html

The entry mentions that the bean cannot be registered immediately within the WHEN_NEW_FORM_INSTANCE trigger, and shows how to delay this slightly using a timer.

Special thanks to Francois Degrelle for the blog entry linked above, and to Frank Nimphius, for the blog entry that pointed me there! :)

Eric Adamson
Lansing, Michigan
495335
I've discovered what my problem was, and it was silly. I had updated the archive_jini entry that appears in my webutil config, but in this case, I was not specifying that config when calling frmservlet, so the JAR was not being downloaded. (DOH!)

Eric
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 31 2005
Added on Mar 3 2005
#database-key-features, #globalization-support
1 comment
637 views