[jira] [Commented] (TRAFODION-3142) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference Manual*

[ASF GitHub Bot (JIRA)]

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

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

Github user liuyu000 commented on a diff in the pull request:

    https://github.com/apache/trafodion/pull/1644#discussion_r202873886
  
    --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
    @@ -2963,18 +2963,22 @@ column-definition is:
     <<<
     ```
     data-type is:
    -    char[acter] [(length [characters])]
    -          [character set char-set-name]
    -          [upshift] [[not]casespecific]
    +    char[acter] [length [characters]]
    +                [character set char-set-name]
    +                [upshift] [[not]casespecific]
       | char[acter] varying (length [characters])
    -          [character set char-set-name]
    -          [upshift] [[not]casespecific]
    -  | varchar (length) [character set char-set-name]
    +                        [character set char-set-name]
    +                        [upshift] [[not]casespecific]
    +  | varchar (length [characters]) 
    +            [character set char-set-name]
    +            [upshift] [[not]casespecific]
    +  | varchar2 (length [characters]) 
    +             [character set char-set-name]
    +             [upshift] [[not]casespecific]          
    +  | nchar [length [characters]]
    --- End diff --
    
    Same as above.
    `length [characters]` is optional.
    
    
![default](https://user-images.githubusercontent.com/20532956/42792008-e8a9cb4c-89a5-11e8-8066-3a39caa307f3.png)



> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *CREATE TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> -------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-3142
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3142
>             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)