Author: paul
Date: 2007-07-13 03:39:27 +0200 (Fri, 13 Jul 2007)
New Revision: 7110
Log:
r22709@frost: paul | 2007-07-12 19:14:51 -0500
Document some overlooked literal-value syntaxes:
- \N (synonym for NULL)
- 0bnnn (bit-value)
- N'abc', n'abc' - utf8 string (mentioned in charset chapter, but not langref)
Modified:
trunk/refman-4.1/charset.xml
trunk/refman-4.1/language-structure.xml
trunk/refman-5.0/charset.xml
trunk/refman-5.0/language-structure.xml
trunk/refman-5.1/charset.xml
trunk/refman-5.1/language-structure.xml
trunk/refman-5.2/charset.xml
trunk/refman-5.2/language-structure.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27614
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22708
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18941
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27614
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22709
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18941
Modified: trunk/refman-4.1/charset.xml
===================================================================
--- trunk/refman-4.1/charset.xml 2007-07-13 01:39:11 UTC (rev 7109)
+++ trunk/refman-4.1/charset.xml 2007-07-13 01:39:27 UTC (rev 7110)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 3; 816 bytes
@@ -1018,13 +1018,15 @@
<para>
You can use
- <literal>N'<replaceable>literal</replaceable>'</literal> to
- create a string in the national character set. These two
- statements are equivalent:
+ <literal>N'<replaceable>literal</replaceable>'</literal> (or
+ <literal>n'<replaceable>literal</replaceable>'</literal>) to
+ create a string in the national character set. These statements
+ are equivalent:
</para>
<programlisting>
SELECT N'some text';
+SELECT n'some text';
SELECT _utf8'some text';
</programlisting>
Modified: trunk/refman-4.1/language-structure.xml
===================================================================
--- trunk/refman-4.1/language-structure.xml 2007-07-13 01:39:11 UTC (rev 7109)
+++ trunk/refman-4.1/language-structure.xml 2007-07-13 01:39:27 UTC (rev 7110)
Changed blocks: 2, Lines Added: 18, Lines Deleted: 2; 1266 bytes
@@ -148,8 +148,23 @@
</programlisting>
<para>
+ You can use
+ <literal>N'<replaceable>literal</replaceable>'</literal> (or
+ <literal>n'<replaceable>literal</replaceable>'</literal>) to
+ create a string in the national character set. These statements
+ are equivalent:
+ </para>
+
+<programlisting>
+SELECT N'some text';
+SELECT n'some text';
+SELECT _utf8'some text';
+</programlisting>
+
+ <para>
For more information about these forms of string syntax, see
- <xref linkend="charset-literal"/>.
+ <xref linkend="charset-literal"/>, and
+ <xref linkend="charset-national"/>.
</para>
<para>
@@ -712,7 +727,8 @@
<para>
The <literal>NULL</literal> value means <quote>no data.</quote>
- <literal>NULL</literal> can be written in any lettercase.
+ <literal>NULL</literal> can be written in any lettercase. A
+ synonym is <literal>\N</literal> (case sensitive).
</para>
<para>
Modified: trunk/refman-5.0/charset.xml
===================================================================
--- trunk/refman-5.0/charset.xml 2007-07-13 01:39:11 UTC (rev 7109)
+++ trunk/refman-5.0/charset.xml 2007-07-13 01:39:27 UTC (rev 7110)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 3; 816 bytes
@@ -1010,13 +1010,15 @@
<para>
You can use
- <literal>N'<replaceable>literal</replaceable>'</literal> to
- create a string in the national character set. These two
- statements are equivalent:
+ <literal>N'<replaceable>literal</replaceable>'</literal> (or
+ <literal>n'<replaceable>literal</replaceable>'</literal>) to
+ create a string in the national character set. These statements
+ are equivalent:
</para>
<programlisting>
SELECT N'some text';
+SELECT n'some text';
SELECT _utf8'some text';
</programlisting>
Modified: trunk/refman-5.0/language-structure.xml
===================================================================
--- trunk/refman-5.0/language-structure.xml 2007-07-13 01:39:11 UTC (rev 7109)
+++ trunk/refman-5.0/language-structure.xml 2007-07-13 01:39:27 UTC (rev 7110)
Changed blocks: 3, Lines Added: 22, Lines Deleted: 5; 1813 bytes
@@ -148,8 +148,23 @@
</programlisting>
<para>
+ You can use
+ <literal>N'<replaceable>literal</replaceable>'</literal> (or
+ <literal>n'<replaceable>literal</replaceable>'</literal>) to
+ create a string in the national character set. These statements
+ are equivalent:
+ </para>
+
+<programlisting>
+SELECT N'some text';
+SELECT n'some text';
+SELECT _utf8'some text';
+</programlisting>
+
+ <para>
For more information about these forms of string syntax, see
- <xref linkend="charset-literal"/>.
+ <xref linkend="charset-literal"/>, and
+ <xref linkend="charset-national"/>.
</para>
<para>
@@ -704,9 +719,10 @@
<para>
Beginning with MySQL 5.0.3, bit-field values can be written
- using <literal>b'<replaceable>value</replaceable>'</literal>
- notation. <replaceable>value</replaceable> is a binary value
- written using zeros and ones.
+ using <literal>b'<replaceable>value</replaceable>'</literal> or
+ <literal>0b<replaceable>value</replaceable></literal> notation.
+ <replaceable>value</replaceable> is a binary value written using
+ zeros and ones.
</para>
<para>
@@ -770,7 +786,8 @@
<para>
The <literal>NULL</literal> value means <quote>no data.</quote>
- <literal>NULL</literal> can be written in any lettercase.
+ <literal>NULL</literal> can be written in any lettercase. A
+ synonym is <literal>\N</literal> (case sensitive).
</para>
<para>
Modified: trunk/refman-5.1/charset.xml
===================================================================
--- trunk/refman-5.1/charset.xml 2007-07-13 01:39:11 UTC (rev 7109)
+++ trunk/refman-5.1/charset.xml 2007-07-13 01:39:27 UTC (rev 7110)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 3; 816 bytes
@@ -1010,13 +1010,15 @@
<para>
You can use
- <literal>N'<replaceable>literal</replaceable>'</literal> to
- create a string in the national character set. These two
- statements are equivalent:
+ <literal>N'<replaceable>literal</replaceable>'</literal> (or
+ <literal>n'<replaceable>literal</replaceable>'</literal>) to
+ create a string in the national character set. These statements
+ are equivalent:
</para>
<programlisting>
SELECT N'some text';
+SELECT n'some text';
SELECT _utf8'some text';
</programlisting>
Modified: trunk/refman-5.1/language-structure.xml
===================================================================
--- trunk/refman-5.1/language-structure.xml 2007-07-13 01:39:11 UTC (rev 7109)
+++ trunk/refman-5.1/language-structure.xml 2007-07-13 01:39:27 UTC (rev 7110)
Changed blocks: 3, Lines Added: 20, Lines Deleted: 3; 1667 bytes
@@ -148,8 +148,23 @@
</programlisting>
<para>
+ You can use
+ <literal>N'<replaceable>literal</replaceable>'</literal> (or
+ <literal>n'<replaceable>literal</replaceable>'</literal>) to
+ create a string in the national character set. These statements
+ are equivalent:
+ </para>
+
+<programlisting>
+SELECT N'some text';
+SELECT n'some text';
+SELECT _utf8'some text';
+</programlisting>
+
+ <para>
For more information about these forms of string syntax, see
- <xref linkend="charset-literal"/>.
+ <xref linkend="charset-literal"/>, and
+ <xref linkend="charset-national"/>.
</para>
<para>
@@ -705,7 +720,8 @@
<para>
Bit-field values can be written using
- <literal>b'<replaceable>value</replaceable>'</literal> notation.
+ <literal>b'<replaceable>value</replaceable>'</literal> or
+ <literal>0b<replaceable>value</replaceable></literal> notation.
<replaceable>value</replaceable> is a binary value written using
zeros and ones.
</para>
@@ -771,7 +787,8 @@
<para>
The <literal>NULL</literal> value means <quote>no data.</quote>
- <literal>NULL</literal> can be written in any lettercase.
+ <literal>NULL</literal> can be written in any lettercase. A
+ synonym is <literal>\N</literal> (case sensitive).
</para>
<para>
Modified: trunk/refman-5.2/charset.xml
===================================================================
--- trunk/refman-5.2/charset.xml 2007-07-13 01:39:11 UTC (rev 7109)
+++ trunk/refman-5.2/charset.xml 2007-07-13 01:39:27 UTC (rev 7110)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 3; 816 bytes
@@ -1010,13 +1010,15 @@
<para>
You can use
- <literal>N'<replaceable>literal</replaceable>'</literal> to
- create a string in the national character set. These two
- statements are equivalent:
+ <literal>N'<replaceable>literal</replaceable>'</literal> (or
+ <literal>n'<replaceable>literal</replaceable>'</literal>) to
+ create a string in the national character set. These statements
+ are equivalent:
</para>
<programlisting>
SELECT N'some text';
+SELECT n'some text';
SELECT _utf8'some text';
</programlisting>
Modified: trunk/refman-5.2/language-structure.xml
===================================================================
--- trunk/refman-5.2/language-structure.xml 2007-07-13 01:39:11 UTC (rev 7109)
+++ trunk/refman-5.2/language-structure.xml 2007-07-13 01:39:27 UTC (rev 7110)
Changed blocks: 3, Lines Added: 20, Lines Deleted: 3; 1667 bytes
@@ -148,8 +148,23 @@
</programlisting>
<para>
+ You can use
+ <literal>N'<replaceable>literal</replaceable>'</literal> (or
+ <literal>n'<replaceable>literal</replaceable>'</literal>) to
+ create a string in the national character set. These statements
+ are equivalent:
+ </para>
+
+<programlisting>
+SELECT N'some text';
+SELECT n'some text';
+SELECT _utf8'some text';
+</programlisting>
+
+ <para>
For more information about these forms of string syntax, see
- <xref linkend="charset-literal"/>.
+ <xref linkend="charset-literal"/>, and
+ <xref linkend="charset-national"/>.
</para>
<para>
@@ -705,7 +720,8 @@
<para>
Bit-field values can be written using
- <literal>b'<replaceable>value</replaceable>'</literal> notation.
+ <literal>b'<replaceable>value</replaceable>'</literal> or
+ <literal>0b<replaceable>value</replaceable></literal> notation.
<replaceable>value</replaceable> is a binary value written using
zeros and ones.
</para>
@@ -771,7 +787,8 @@
<para>
The <literal>NULL</literal> value means <quote>no data.</quote>
- <literal>NULL</literal> can be written in any lettercase.
+ <literal>NULL</literal> can be written in any lettercase. A
+ synonym is <literal>\N</literal> (case sensitive).
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7110 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.2 | paul | 13 Jul |
