You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by li...@apache.org on 2018/07/20 02:17:14 UTC
[3/7] trafodion git commit: Incorporate Comments 1
Incorporate Comments 1
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/858bb721
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/858bb721
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/858bb721
Branch: refs/heads/master
Commit: 858bb7216fe1c78aa67fb2ac6990d403ef2794b4
Parents: dfa4c2e
Author: liu.yu <qw...@hotmail.com>
Authored: Tue Jul 17 10:45:50 2018 +0800
Committer: liu.yu <qw...@hotmail.com>
Committed: Tue Jul 17 10:45:50 2018 +0800
----------------------------------------------------------------------
.../src/asciidoc/_chapters/sql_statements.adoc | 43 ++------------------
1 file changed, 3 insertions(+), 40 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/858bb721/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
index 88bd40a..4ba9c76 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
@@ -3716,13 +3716,14 @@ ATTRIBUTES ALIGNED FORMAT
--- SQL operation complete.
```
-* This example demonstrates the character set of NCHAR column (_c1_) *cannot be specified*.
+* NATIONAL CHAR (or NCHAR) is a short-hand for CHARACTER SET UCS2.
+So it is not possible to specify a CHARACTER SET clause when using NCHAR,
+as the following example shows.
+
NOTE: NCHAR or NATIONAL CHAR implicitly assumes that the character set is *UCS2*,
whether the character set was specified at installation time to be ISO88591 or UTF8,
and the character set (UCS2) of NCHAR or NATIONAL CHAR *cannot be specified* or *altered*.
This is true for both *CREATE* and *ALTER* statement.
-
+
```
SQL>CREATE TABLE test1 (c1 NCHAR(10) CHARACTER SET USC2);
@@ -3732,44 +3733,6 @@ create table test1 (c1 nchar(10) character set usc2);
^ (40 characters from start of SQL statement) [2018-07-13 04:02:39]
```
-+
-```
-SQL>CREATE TABLE test1 (c1 NCHAR(10) CHARACTER SET UTF8);
-
-*** ERROR[15001] A syntax error occurred at or before:
-create table test1 (c1 nchar(10) character set utf8);
- ^ (40 characters from start of SQL statement) [2018-07-13 05:53:52]
-```
-
-+
-```
-SQL>CREATE TABLE test1 (c1 NCHAR(10) CHARACTER SET ISO88591);
-
-*** ERROR[15001] A syntax error occurred at or before:
-create table test1 (c1 nchar(10) character set iso88591);
- ^ (40 characters from start of SQL statement) [2018-07-13 05:55:47]
-```
-
-+
-```
-SQL>CREATE TABLE test1 (c1 nchar(10));
-
---- SQL operation complete.
-
-
-SQL>SHOWDDL test1;
-
-CREATE TABLE TRAFODION.SEABASE.TEST1
- (
- C1 CHAR(10) CHARACTER SET UCS2 COLLATE
- DEFAULT DEFAULT NULL NOT SERIALIZED
- )
- ATTRIBUTES ALIGNED FORMAT
-;
-
---- SQL operation complete.
-```
-
<<<
[[create_table_examples_create_table_as]]
==== Examples of CREATE TABLE AS