trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liuyu000 <...@git.apache.org>
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:

    https://github.com/apache/trafodion/pull/1544#discussion_r185458080
  
    --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
---
    @@ -581,12 +581,12 @@ characters. See <<character_value_expressions,Character Value
Expressions>>.
     [[considerations_for_ascii]]
     === 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**.
    ![default](https://user-images.githubusercontent.com/20532956/39507086-f92c42f6-4e0e-11e8-8ec8-f47d2c5ae2bc.png)
    
        I also tried  `SELECT ASCII('ÿ')` on UTF8 column, it did **not** generate an error
either (**double-byte**).
    ![default](https://user-images.githubusercontent.com/20532956/39507420-66439ff0-4e10-11e8-8838-764325c20cb8.png)
    
        Then I tried `SELECT ASCII('A')` on UTF8 column, it runs successfully (**single-byte**):
    ![default](https://user-images.githubusercontent.com/20532956/39507733-f2157994-4e11-11e8-8601-1744ce70d0e3.png)
    
    2. I inserted the Chinese character ‘昱’ and tried the same thing, it returned an
error (which seems right, **double-byte**):
    ![default](https://user-images.githubusercontent.com/20532956/39507210-82f56d50-4e0f-11e8-9926-3ad3057279fc.png)
    
    
    
    
    
     


---

Mime
View raw message