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/ba4e6e47 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/ba4e6e47 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/ba4e6e47 Branch: refs/heads/master Commit: ba4e6e4748bac4bab22985d925e83e73eebb1e75 Parents: aec1a46 Author: liu.yu <[email protected]> Authored: Tue Jul 17 11:14:07 2018 +0800 Committer: liu.yu <[email protected]> Committed: Tue Jul 17 11:14:07 2018 +0800 ---------------------------------------------------------------------- docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/ba4e6e47/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 c9c30b5..3654577 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc @@ -394,7 +394,7 @@ column-definition is: [[constraint constraint-name] column-constraint]] data-type is: - char[acter] [(length)[characters]] + char[acter] [length [characters]] [CHARACTER SET char-set-name] [UPSHIFT] [[NOT] CASESPECIFIC] | char[acter] varying (length [characters]) @@ -758,7 +758,9 @@ Alter TABLE PRODUCT ALTER COLUMN vend_id RENAME TO cstm_id; ``` -* This example demonstrates the character set of NCHAR column cannot be altered. +* NATIONAL CHAR (or NCHAR) is a short-hand for CHARACTER SET UCS2, so it is not possible to alter the CHARACTER SET 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,
