[
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)
