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!

Oracle 11g special character(á) length count

827320Feb 7 2011 — edited Feb 8 2011
Hi Experts,

I'm facing an issue while inserting the special character (á) in Oracle 11g. The database table length for the column 'descr' declared as varchar2(30). I'm inserting a string ('Aabbccee/ddffggh Ffrán y Plaos') in column descr which is having the length 30. Please note the character 'a' in Ffrán is not letter 'a' but special character *'á'*. It gives the below error,

java.sql.SQLException: ORA-12899: value too large for column ""DESCR" (actual: 31, maximum: 30)

The strange is the same query works/insert in Oracle 9i without any issue. I suspect the special character *'á'* will take/count as 2 character in Oracle 11g but single character in Oracle 9i.

Please provide the insight views and solution for this issue with out altering the column length.

I hope the solution at the earliest, since this is an urgent requirement.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2011
Added on Feb 7 2011
#11g, #database, #error, #general-database-discussions, #oracle, #sql, #table
7 comments
6,977 views