Bug 115938

Description of problem:
The Bebop StringLengthValidationListener checks the length of a string
parameters in characters to ensure it does not exceed a specified
limit. Practically every single form in WAF is then used to create a
DomainObject in the DB. While on PostgreSQL VARCHAR fields are
measured in characters, on Oracle the default setting is to measure in
bytes. Thus if there is a VARCHAR(200) field and the user enters 200
Thai characters, this will likely come out at more like 600 bytes,
thus totally overflowing the data type in oracle.

We should either create a new DBStringLengthValidationListener that
measures using the size units of the current configured DB, or modify
existing StringLengthValidationListener. If the former, we will have
to additionally search & replace neearly every single occurrance of
StringLengthValidationListener.

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. Create a new CMS Item
2. Enter 200 characters of Thai
3. Save the form
  
Actual results:
Kaboom

Expected results:
Validation warning

Additional info:

See Vadim's posting:

http://post-office.corp.redhat.com/archives/ccm-engineering-list/2004-February/msg00036.html