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

Reference manual is unclear on max length for VARCHAR

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.5.3.0
    • 10.6.1.0
    • Documentation
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: