Resolution: Won't Fix
Affects Version/s: 6.2.10 EE GA1, 6.2.X EE
Fix Version/s: None
Liferay permits up to 4000 characters in a varchar2 field but Oracle 11g and 12c default to a 4000 byte limit. If multi-byte characters are used as input, an exception like the following can be encountered:
Steps to Reproduce:
1. Configure Liferay Portal 6.2 EE to use Oracle Database.
2. Navigate to Control Panel > Server Admin > Script.
3. Create a user via the User menu with the screen name "omniadmin".
4. Run the attached Groovy Script which attempts to set user comments
Since less than 4000 characters are used, the user's comments will be updated.
User comments are not updated because Oracle is using a byte limit, not a character limit.
Issue reproduced in branch.
Cannot test in Master; Master is not compatible with Oracle.