Skip to Main Content

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.

International Character support

Warren SAug 7 2014 — edited Aug 9 2014

We are in the process of converting from Oracle 10g to Oracle 11g.  We have a spatial table that contains a column for city.  In the 10g database the column is defined as varchar2(50) in the 11g database it's defined as nvarchar2(50).  The database is defined as UTF8.  In the 10g database the data was inserted using and ESRI sde command executed from a Pro*C program.  In Oracle 11 we're using a SQL "insert" statement to insert the record to the table.  In the case of 'MONTRÉAL' the E with the accent mark is not being saved correctly to the database.  If you run a SQL insert using SQLPLUS on the database server to insert the record and then select the record it looks correct but if you use SQLDeveloper on a Windows7 machine the E in not printable.  What needs to be set for the Pro*C program to communicate correctly with the Oracle 11 database when using international characters.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 6 2014
Added on Aug 7 2014
5 comments
1,581 views