trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DaveBirdsall <...@git.apache.org>
Subject [GitHub] trafodion pull request #1634: [TRAFODION-3132] Add and Correct Descriptions ...
Date Mon, 09 Jul 2018 21:11:36 GMT
Github user DaveBirdsall commented on a diff in the pull request:

    https://github.com/apache/trafodion/pull/1634#discussion_r201148299
  
    --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc ---
    @@ -396,21 +396,22 @@ length of 8 bytes.
     * _precision_ specifies the allowed number of decimal digits.
     
     
    -1.  The size of a column that allows null values is 2 bytes larger than the size for
the defined data type.
    -2.  The maximum row size is 32708 bytes, but the actual row size is less than that because
of bytes used by
    -null indicators, varchar column length indicators, and actual data encoding.
    -3.  Storage size is the same as that required by CHAR data type but store only half as
many characters depending
    -on character set selection.
    -4.  Storage size is reduced by 4 bytes for storage of the varying character length.
    -5.  The maximum number of digits in an INTERVAL value is 18, including the digits in
all INTERVAL fields of the value.
    +1. The size of a column that allows null values is 2 bytes larger than the size for the
defined data type.
    +2. Storage size is the same as that required by CHAR data type but store only half.
    --- End diff --
    
    Perhaps what you mean in footnote 2 is: "The maximum number of characters depends on the
character set. For 8-bit character sets such as ISO88591, the maximum number of characters
is equal to the maximum storage size in bytes. For 16-bit character sets such as UCS2, the
maximum number of characters is half the maximum storage size in bytes. For character sets
requiring up to 32 bits per character such as UTF8, the maximum number of characters is one
fourth the maximum storage size in bytes."


---

Mime
View raw message