trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From li...@apache.org
Subject [3/7] trafodion git commit: Incorporate Comments 1
Date Fri, 20 Jul 2018 02:17:14 GMT
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 <qwertyioz@hotmail.com>
Authored: Tue Jul 17 10:45:50 2018 +0800
Committer: liu.yu <qwertyioz@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


Mime
View raw message