Quantcast

TRANSLATORS: please refresh your source files

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

TRANSLATORS: please refresh your source files

Helen Borrie-2
Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25
In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv27364

Modified Files:
        fblangref25-commons.xml fblangref25-dml.xml
        fblangref25-structure.xml fblangref25.xml
Log Message:
A few additions and corrections in response to reports in firebird-docs. Translators, please refresh the files fblangref25-commons, fblangref25-dml, fblangref25-structure and fblangref25. New build no. is 0.901.

Index: fblangref25-dml.xml
===================================================================
RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-dml.xml,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- fblangref25-dml.xml 26 Jan 2016 21:01:21 -0000      1.4
+++ fblangref25-dml.xml 2 Feb 2016 21:10:21 -0000       1.5
@@ -4261,17 +4261,13 @@
       if the column list is absent, the engine requires a value for every
       column in the table or view (computed columns excluded).</para>
 
-      <section id="fblangref25-dml-insert-values-character">
-        <title>Introducer Syntax for String Literals</title>
-        <para>String literals may optionally be preceded by a character set
-        name, itself prefixed with an underscore <quote>_</quote>.  This is known
-        as <firstterm>introducer syntax</firstterm>.  Its purpose is to inform
-        the engine as to how it is to interpret and store the incoming string.</para>
         <note>
-          <para>Introducer syntax works only with literal strings.  It cannot be
-          applied directly to string variables, parameters or function expressions.</para>
+          <para><link linkend="fblangref25-commons-introducer-syntax">Introducer syntax</link>
+          provides a way to identify the character set of a value that is a string
+          constant (literal). Introducer syntax works only with literal strings:  it cannot
+          be applied to string variables, parameters, column references or values that
+          are expressions.</para>
         </note>
-      </section>
 
       <formalpara>
         <title>Examples</title>
@@ -4283,7 +4279,7 @@
 INSERT INTO cars
 VALUES ('Ford', 'T', 1908, 'USA', 850);
 
--- notice the '_' prefix
+-- notice the '_' prefix (introducer syntax)
 INSERT INTO People
 VALUES (_ISO8859_1 'Hans-J&ouml;rg Sch&auml;fer')
           </programlisting></blockquote>
@@ -4728,7 +4724,7 @@
         </para>
 <!-- introducer syntax -->
         <para>For string literals with which the parser needs help to interpret the character
-        set of the data, the <link linkend="fblangref25-dml-insert-values-character">introducer
+        set of the data, the <link linkend="fblangref25-commons-introducer-syntax">introducer
         syntax</link> may be used.  The string literal is preceded by the character set name,
         prefixed with an underscore character:
           <blockquote><programlisting>

Index: fblangref25-commons.xml
===================================================================
RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-commons.xml,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- fblangref25-commons.xml     12 Sep 2015 20:55:07 -0000      1.4
+++ fblangref25-commons.xml     2 Feb 2016 21:10:21 -0000       1.5
@@ -135,6 +135,64 @@
       </tgroup>
     </table>
 
+    <section id="fblangref25-commons-constants">
+      <title>Constants</title>
+      <para>A constant is a value that is supplied directly in an SQL statement, not derived from an expression,
+      a parameter, a column reference nor a variable.  It can be a string or a number.</para>
+
+      <section id="fblangref25-commons-string-constant">
+        <title>String Constants (Literals)</title>
+        <para>A string constant is a series of characters enclosed between a pair of apostrophes
+        (<quote>single quotes</quote>).  The maximum length of a string is 32,767 bytes;  the
+        maximum character count will be determined by the number of bytes used to encode each
+        character.</para>
+        <note>
+          <itemizedlist>
+            <listitem>Double quotes are <emphasis>NOT VALID</emphasis> for quoting strings.
+            SQL reserves a different purpose for them.</listitem>
+            <listitem>If a literal apostrophe is required within a string constant, it is
+            <quote>escaped</quote> by prefixing it with another apostrophe.  For example,
+            <filename>'Mother O''Reilly's home-made hooch'</filename>.</listitem>
+            <listitem>Care should be taken with the string length if the value is to be
+            written to a <database>VARCHAR</database> column.  The maximum length for a
+            <database>VARCHAR</database> is 32,765 bytes.</listitem>
+          </itemizedlist>
+        </note>
+        <para>The character set of a string constant is assumed to be the same as the character set of
+        its destined storage.</para>
+
+        <section id="fblangref25-commons-introducer-syntax">
+          <title>Introducer Syntax for String Literals</title>
+          <para>If necessary, a string literal may be preceded by a character set
+          name, itself prefixed with an underscore <quote>_</quote>.  This is known
+          as <firstterm>introducer syntax</firstterm>.  Its purpose is to inform
+          the engine about how to interpret and store the incoming string.</para>
+          <para>Example
+          <blockquote><programlisting>
+INSERT INTO People
+VALUES (_ISO8859_1 'Hans-J&ouml;rg Sch&auml;fer')
+            </programlisting></blockquote>
+          </para>
+        </section>
+      </section>
+
+      <section id="fblangref25-commons-number-constant">
+        <title>Number Constants</title>
+        <para>A number constant is any valid number in a supported notation:
+          <itemizedlist>
+            <listitem>In SQL, for numbers in the standard decimal notation, the decimal point is
+            always represented by period (full-stop, dot) character and thousands are not
+            separated.  Inclusion of commas, blanks, etc. will cause errors.</listitem>
+            <listitem>Exponential notation is supported.  For example, 0.0000234 can be expressed
+            as <filename>2.34e-5</filename>.</listitem>
+            <listitem>For <database>BIGINT</database> numbers, hexadecimal notation is supported
+            by Firebird 2.5 and higher versions,
+            e.g., 0X080000000 as the hex representation of decimal 2147483648.</listitem>
+          </itemizedlist>
+        </para>
+      </section>
+    </section>
+
     <section id="fblangref25-commons-sqloperators">
       <title>SQL Operators</title>
       <para>SQL operators comprise operators for comparing, calculating, evaluating and concatenating values.</para>
@@ -939,7 +997,7 @@
           <para>The <database>CONTAINING</database> predicate searches for a string or a string-like
           type looking for the sequence of characters that matches its argument. It can be used for
           an alphanumeric (string-like) search on numbers and dates. A <database>CONTAINING</database>
-          search is case-sensitive.</para>
+          search is not case-sensitive.</para>
           <para>When <database>CONTAINING</database> is used in the search conditions of DML queries,
           the Firebird optimizer can use an index on the searched column, if a suitable one exists.</para>
           <formalpara><title>Examples</title>

Index: fblangref25-structure.xml
===================================================================
RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-structure.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- fblangref25-structure.xml   8 Sep 2015 02:48:52 -0000       1.2
+++ fblangref25-structure.xml   2 Feb 2016 21:10:21 -0000       1.3
@@ -269,7 +269,7 @@
     <para>Literals are used to represent data in a direct format.  Examples of standard types of literals
     are:</para>
     <literallayout class="monospaced">
-          integer - 0, -34, 45;
+          integer - 0, -34, 45, 0X080000000;
           real - 0.0, -3.14, 3.23e-23;
           string - 'text', 'don''t!';
           date - DATE '10.01.2014';

Index: fblangref25.xml
===================================================================
RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25.xml,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -d -r1.17 -r1.18
--- fblangref25.xml     29 Jan 2016 22:23:08 -0000      1.17
+++ fblangref25.xml     2 Feb 2016 21:10:21 -0000       1.18
@@ -5,7 +5,7 @@
   <bookinfo>
     <title>Firebird 2.5 Language Reference</title>
     <subtitle>Beta Release 1</subtitle>
-    <edition>26 January 2016, document version 0.900</edition>
+    <edition>2 February 2016, document version 0.901</edition>
     <authorgroup>
       <author>
         <firstname>Dmitry</firstname>
@@ -42,19 +42,13 @@
         <contrib>The source of much copied
         reference material</contrib>
     </othercredit>
-    <othercredit>
-        <firstname>Thomas</firstname>
-        <surname>Woinke</surname>
-        <contrib>Another source of copied
-        reference material</contrib>
-    </othercredit>
 
     <publisher>
       <publishername>Firebird Project</publishername>
     </publisher>
     <copyright>
-      <year>2015</year>
-      <holder>Firebird Project and all contributing authors, under the
+      <year>2016</year>
+      <holder>Firebird Project and all contributing authors, under the
       <ulink url="http://www.firebirdsql.org/manual/pdl.html">Public Documentation License
       Version 1.0</ulink>. Please refer to the <link linkend="fblangref25-license">License Notice
       in the Appendix</link>.




------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Firebird-docs mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-docs
Loading...