trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liuyu000 <>
Subject [GitHub] trafodion pull request #1544: [TRAFODION-3048] Correct the Syntax Descriptio...
Date Wed, 02 May 2018 10:50:21 GMT
Github user liuyu000 commented on a diff in the pull request:
    --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
    @@ -581,12 +581,12 @@ characters. See <<character_value_expressions,Character Value
     === Considerations For ASCII
    -For a string expression in the UTF8 character set, if the value of the
    +If the value of the
    --- End diff --
    @DaveBirdsall Thanks for your explanations :)
    1. I tried `SELECT ASCII('ñ')` on UTF8 column but found a different behaviour: it did
**not** generate an error.
    And the 'ñ', which is larger than 127, is **double-byte**.
        I also tried  `SELECT ASCII('ÿ')` on UTF8 column, it did **not** generate an error
either (**double-byte**).
        Then I tried `SELECT ASCII('A')` on UTF8 column, it runs successfully (**single-byte**):
    2. I inserted the Chinese character ‘昱’ and tried the same thing, it returned an
error (which seems right, **double-byte**):


View raw message