[GitHub] trafodion pull request #1544: [TRAFODION-3048] Correct the Syntax Descriptio...

[liuyu000]

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)
    
    
    
    
    
     


---