Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25
In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv17868
Modified Files:
fblangref25-commons.xml fblangref25-datatypes.xml
fblangref25-ddl.xml fblangref25-functions-vars.xml
fblangref25-structure.xml fblangref25.xml
Log Message:
Corrections and additions from reviewers Feb/Mar 2016. Translators please pick
up details of changes in firebird-docs.
Index: fblangref25-functions-vars.xml
===
RCS file:
/cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-functions-vars.xml,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- fblangref25-functions-vars.xml 26 Jan 2016 21:01:21 - 1.4
+++ fblangref25-functions-vars.xml 27 Mar 2016 21:20:48 - 1.5
@@ -2,7 +2,7 @@
- Built-in functions and variables
+ Built-in functions and Variables
Index: fblangref25-commons.xml
===
RCS file:
/cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-commons.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- fblangref25-commons.xml 2 Feb 2016 21:10:21 - 1.5
+++ fblangref25-commons.xml 27 Mar 2016 21:20:47 - 1.6
@@ -5,7 +5,8 @@
Common Language Elements
This chapter covers the elements that are common throughout the
implementation of the
SQL language—the expressions that are used to
extract and operate
-on facts from data and the predicates that test the
truth of those facts.
+on assertions about data and the predicates that
test the truth of those
+assertions.
Expressions
SQL expressions provide formal methods for evaluating, transforming
and comparing
@@ -34,7 +35,10 @@
Array element
-An expression may contain a reference to an
array element
+An expression may contain a reference to an
array member
+i.e., [s],
+where s is the subscript of the member
in the array
+
Arithmetic operators
@@ -81,7 +85,8 @@
Context variable
-An internally-defined context variable
+An internally-defined context
+variable
Local variable
@@ -118,13 +123,13 @@
Parentheses
Bracket pairs (…) used to group
expressions.
Operations inside the parentheses are performed before operations
outside them. When
-embedded parentheses are used, the most deeply embedded
expressions are evaluated
-first and then the evaluations move outward through the levels of
embedding
+nested parentheses are used, the most deeply nested expressions
are evaluated
+first and then the evaluations move outward through the levels of
nesting.
COLLATE clause
-Clause applied to CHAR and VARCHAR types to
specify the collation
-sequence to use in string comparisons
+Clause applied to CHAR and VARCHAR types to
specify the
+character-set-specific collation sequence to use in string
comparisons
NEXT VALUE FOR
sequence
@@ -161,6 +166,54 @@
The character set of a string constant is assumed to be the same
as the character set of
its destined storage.
+
+
+ String Constants in Hexadecimal Notation
+ From Firebird 2.5 forward, string literals can be entered in
hexadecimal notation,
+ so-called binary strings. Each pair of hex digits
defines one byte in
+ the string. Strings entered this way will have character set
OCTETS
+ by default but the introducer
+ syntax can be used to force a string to be
interpreted as another character set.
+
+Syntax
+
+
+{x|X}''
+
+ > ::= an even number of
+ ::= one of 0..9, A..F, a..f
+
+
+
+
+
+Examples
+
+select x'4E657276656E' from rdb$database
+ -- returns 4E657276656E, a 6-byte 'binary' string
+
+select _ascii x'4E657276656E' from rdb$database
+ -- returns 'Nerven' (same string, now interpreted as ASCII text)
+
+select _iso8859_1 x'53E46765' from rdb$database
+ -- returns 'Säge' (4 chars, 4 bytes)
+
+select _utf8 x'53C3A46765' from rdb$database
+ -- returns 'Säge' (4 chars, 5 bytes)
+
+
+
+Notes
+The client interface determines how binary strings are
displayed to the user.
+