Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4510

Reference manual is unclear on max length for VARCHAR

    Details

    • 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
    • Labels:
      None

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

        Attachments

        1. docs.diff
          1 kB
          Bryan Pendleton
        2. rrefsqlj41207.html
          4 kB
          Bryan Pendleton

          Activity

            People

            • Assignee:
              bryanpendleton Bryan Pendleton
              Reporter:
              knutanders Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: