You are viewing a plain text version of this content. The canonical link for it is here.
Posted to codereview@trafodion.apache.org by liuyu000 <gi...@git.apache.org> on 2018/05/02 10:50:21 UTC
[GitHub] trafodion pull request #1544: [TRAFODION-3048] Correct the Syntax Descriptio...
Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1544#discussion_r185458080
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---
@@ -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
--- End diff --
@DaveBirdsall Thanks for your explanations :)
1. I tried `SELECT ASCII('ñ')` on UTF8 column but found a different behaviour: it did **not** generate an error.
And the 'ñ', which is larger than 127, is **double-byte**.

I also tried `SELECT ASCII('ÿ')` on UTF8 column, it did **not** generate an error either (**double-byte**).

Then I tried `SELECT ASCII('A')` on UTF8 column, it runs successfully (**single-byte**):

2. I inserted the Chinese character ‘昱’ and tried the same thing, it returned an error (which seems right, **double-byte**):

---