[ https://issues.apache.org/jira/browse/TRAFODION-3142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16545365#comment-16545365 ]
ASF GitHub Bot commented on TRAFODION-3142: ------------------------------------------- Github user DaveBirdsall commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1644#discussion_r202731971 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -3712,6 +3716,60 @@ ATTRIBUTES ALIGNED FORMAT --- SQL operation complete. ``` +* This example demonstrates the character set of NCHAR column (_c1_) *cannot be specified*. --- End diff -- I think one example is probably enough. The point we are trying to make is that "NATIONAL CHAR" implies a particular character set, namely, "UCS2". This is hard-coded into the product; it cannot be changed. Possible word-smith: "NATIONAL CHAR (or NCHAR) is a short-hand for CHAR ... CHARACTER SET UCS2. So it is not possible to specify a CHARACTER SET clause when using NCHAR, as the following example shows:" > 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)