[jira] [Commented] (TRAFODION-3048) Correct the Syntax Descriptions for *ASCII Fucntion* in Trafodion SQL Reference Manual

Wed, 02 May 2018 03:51:19 -0700 

    [ 
https://issues.apache.org/jira/browse/TRAFODION-3048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16460864#comment-16460864
 ] 

ASF GitHub Bot commented on TRAFODION-3048:
-------------------------------------------

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)
    
    
    
    
    
     


> Correct the Syntax Descriptions for *ASCII Fucntion* in Trafodion SQL 
> Reference Manual
> --------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-3048
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3048
>             Project: Apache Trafodion
>          Issue Type: Documentation
>            Reporter: Liu Yu
>            Assignee: Liu Yu
>            Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to