Repository: trafodion Updated Branches: refs/heads/master 008f4af32 -> c9b7cf08d
Correct the Syntax Descriptions for *ASCII Fucntion* in Trafodion SQL Reference Manuall Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/1c3e1c68 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/1c3e1c68 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/1c3e1c68 Branch: refs/heads/master Commit: 1c3e1c6850f095fc96934305a9e6ab78c548bc87 Parents: 60d717b Author: liu.yu <[email protected]> Authored: Fri Apr 27 12:00:25 2018 +0800 Committer: liu.yu <[email protected]> Committed: Fri Apr 27 12:00:25 2018 +0800 ---------------------------------------------------------------------- .../asciidoc/_chapters/sql_functions_and_expressions.adoc | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/1c3e1c68/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc index 94b5126..324407e 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc @@ -564,8 +564,8 @@ ADD_MONTHS(timestamp'2008-02-29 00:00:00',12,1) == ASCII Function The ASCII function returns the integer that is the ASCII code of the -first character in a character string expression associated with either -the ISO88591 character set or the UTF8 character set. +first character in a character string expression associated with +the ISO88591 character set. ASCII is a {project-name} SQL extension. @@ -581,12 +581,12 @@ characters. See <<character_value_expressions,Character Value Expressions>>. [[considerations_for_ascii]] === Considerations For ASCII -For a string expression in the UTF8 character set, if the value of the +If the value of the first byte in the string is greater than 127, {project-name} SQL returns this error message: ``` -ERROR[8428] The argument to function ASCII is not valid. +ERROR[4106] The character set for the operand of function ASCII must be ISO88591. ``` [[examples_of_ascii]]
