[
https://issues.apache.org/jira/browse/TRAFODION-2665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16060310#comment-16060310
]
ASF GitHub Bot commented on TRAFODION-2665:
-------------------------------------------
Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1137#discussion_r123658976
--- Diff:
docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc ---
@@ -604,39 +604,54 @@ numeric, datetime, or interval data.
* `_character-type_` is:
+
```
-CHAR[ACTER] [(_length_ [CHARACTERS])] [_char-set_] [UPSHIFT]
[[NOT]CASESPECIFIC]
-| CHAR[ACTER] VARYING(_length_) [CHARACTERS][_char-set_] [UPSHIFT]
[[NOT]CASESPECIFIC]
-| VARCHAR(_length_) [CHARACTERS] [_char-set_] [UPSHIFT] [[NOT]CASESPECIFIC]
-| NCHAR [(_length_)] [CHARACTERS] [UPSHIFT] [[NOT]CASESPECIFIC]
-| NCHAR VARYING (_length_) [CHARACTERS] [UPSHIFT] [[NOT]CASESPECIFIC]
-| NATIONAL CHAR[ACTER] [(_length_)] [CHARACTERS] [UPSHIFT]
[[NOT]CASESPECIFIC]
-| NATIONAL CHAR[ACTER] VARYING (_length_) [CHARACTERS] [UPSHIFT]
[[NOT]CASESPECIFIC]
+CHAR[ACTER] [(length [unit])] [char-set] [UPSHIFT] [[NOT]CASESPECIFIC]
+| CHAR[ACTER] VARYING(length [unit]) [char-set] [UPSHIFT]
[[NOT]CASESPECIFIC]
+| VARCHAR(length [unit]) [CHARACTERS] [char-set] [UPSHIFT]
[[NOT]CASESPECIFIC]
+| NCHAR [(length)] [UPSHIFT] [[NOT]CASESPECIFIC]
+| NCHAR VARYING (length) [UPSHIFT] [[NOT]CASESPECIFIC]
+| NATIONAL CHAR[ACTER] [(length)] [UPSHIFT] [[NOT]CASESPECIFIC]
+| NATIONAL CHAR[ACTER] VARYING (length) [UPSHIFT] [[NOT]CASESPECIFIC]
```
-* `_char-set_` is
+
-```
-CHARACTER SET char-set-name
-```
-
CHAR, NCHAR, and NATIONAL CHAR are fixed-length character types. CHAR
VARYING, VARCHAR, NCHAR VARYING and NATIONAL CHAR VARYING are
varying-length character types.
* `_length_`
+
-is a positive integer that specifies the number of characters allowed in
+is a positive integer that specifies the number of characters (or bytes,
see below) allowed in
the column. You must specify a value for _length_.
-* `_char-set-name_`
+* `_unit_`
++
+is an optional unit of either CHAR[ACTER[S]] or BYTE[S]. This unit is
meaningful only for UTF8 characters.
+A UTF8 character is one to four bytes in length, therefore the storage
length of a CHAR column that can hold _n_ UTF8 characters is 4*_n_ bytes.
--- End diff --
Thanks Hans. I've incorporated your comment. :)
> Update Character String Data Types
> ----------------------------------
>
> Key: TRAFODION-2665
> URL: https://issues.apache.org/jira/browse/TRAFODION-2665
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: Liu Yu
> Assignee: Liu Yu
> Priority: Minor
>
> Update *Character String Data Types*
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
