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

        No work has yet been logged on this issue.

          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