[DERBY-4510] Reference manual is unclear on max length for VARCHAR

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.5.3.0
• Fix Version/s: 10.6.1.0
• Component/s: Documentation
• Assignee: Bryan Pendleton
• Reporter: Knut Anders Hatlen
• Created: 08/Jan/10 09:30
• Updated: 02/Feb/10 09:46
• Resolved: 23/Jan/10 20:38

Description

This is what the reference manual says about the length of a VARCHAR:
(http://db.apache.org/derby/docs/10.5/ref/rrefsqlj41207.html)

,----

length is an unsigned integer constant, and it must not be greater

than the constraint of the integer used to specify the length, the

value java.lang.Integer.MAX_VALUE.

The maximum length for a VARCHAR string is 32,672 characters. `----

I don't understand why it talks about Integer.MAX_VALUE here, and I
think it would be less confusing if we replaced the above with this:

,----

length is an unsigned integer constant. The maximum length for a

VARCHAR string is 32,672 characters. `----