Derby
  1. Derby
  2. DERBY-4510

Reference manual is unclear on max length for VARCHAR

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor 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.
      `----
      1. rrefsqlj41207.html
        4 kB
        Bryan Pendleton
      2. docs.diff
        1 kB
        Bryan Pendleton

        Activity

        Knut Anders Hatlen created issue -
        Bryan Pendleton made changes -
        Field Original Value New Value
        Attachment rrefsqlj41207.html [ 12431215 ]
        Attachment docs.diff [ 12431216 ]
        Bryan Pendleton made changes -
        Assignee Bryan Pendleton [ bryanpendleton ]
        Bryan Pendleton made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 10.6.0.0 [ 12313727 ]
        Resolution Fixed [ 1 ]
        Knut Anders Hatlen made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12486363 ] Default workflow, editable Closed status [ 12799605 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development