Reference manual is unclear on max length for VARCHAR
-----------------------------------------------------

                 Key: DERBY-4510
                 URL: https://issues.apache.org/jira/browse/DERBY-4510
             Project: Derby
          Issue Type: Bug
          Components: Documentation
    Affects Versions: 10.5.3.0
            Reporter: Knut Anders Hatlen
            Priority: Minor


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.
`----

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to