SQL & PL/SQL

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!

String length

user9503787Dec 9 2009 — edited Dec 10 2009

Hi I have a column varchar2(100). In the user interface I valiadted the input string only allow 100. But for one test case it passed the UI validation and failed in db insert with error ORA-12899: value too large for column (actual: 106, maximum: 100). I checked the string, only special thing is that (it copied from web browser) it has 2 single quote (’ by viewing the source) and 2 copyright sign (®). Are those causing the problem? How can I detect it? Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 7 2010

Added on Dec 9 2009

2 comments

501 views