Notifications

759 views

Description

Dictionary property 'Max Length' is not enforced. If you put a string value much longer than the specified max length in the database dictionary, it does not cause any error. The problem is that the string is stored and displays fine on MySQL if max length is over 255, but it then gets silently truncated on Oracle.

Steps to Reproduce

  1. Open sys_properties.list.
  2. Go to Personalize > Dictionary.
  3. Check that the dictionary entry for Description specifies a max length of 512.
  4. Edit one of the sys_properties descriptions with text that is longer than 512.
  5. Update the record.

Workaround

Ensure that values in a string field are under 255 characters.


Related Problem: PRB565296

Seen In

Aspen Patch 2
Aspen Patch 2 Hot Fix 5
Berlin Hot Fix 4
Berlin Patch 4
Berlin Patch 4 Hot Fix 1
CCA 4
Dublin EA 8
Dublin Patch 3
Eureka Patch 2
Eureka Patch 6
Eureka Patch 8
Geneva Patch 3 Hot Fix 1

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-12-04 06:45:57
Published:2013-07-11