Author: paul
Date: 2006-02-01 19:44:04 +0100 (Wed, 01 Feb 2006)
New Revision: 1169
Log:
r2767@kite-hub: paul | 2006-02-01 12:04:39 -0600
Explain how to check your charset-related settings.
Modified:
trunk/
trunk/refman-4.1/charset.xml
trunk/refman-5.0/charset.xml
trunk/refman-5.1/charset.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7026
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2749
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7026
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2767
Modified: trunk/refman-4.1/charset.xml
===================================================================
--- trunk/refman-4.1/charset.xml 2006-02-01 16:47:00 UTC (rev 1168)
+++ trunk/refman-4.1/charset.xml 2006-02-01 18:44:04 UTC (rev 1169)
@@ -396,10 +396,10 @@
<para>
There are default settings for character sets and collations at
- four levels: server, database, table, and column. The
- following description may appear complex, but it has been found in
- practice that multiple-level defaulting leads to natural and
- obvious results.
+ four levels: server, database, table, and column. The following
+ description may appear complex, but it has been found in practice
+ that multiple-level defaulting leads to natural and obvious
+ results.
</para>
<para>
@@ -1217,9 +1217,9 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_client = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_results = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_connection = <replaceable>x</replaceable>;</userinput>
+SET character_set_client = <replaceable>x</replaceable>;
+SET character_set_results = <replaceable>x</replaceable>;
+SET character_set_connection = <replaceable>x</replaceable>;
</programlisting>
<para>
@@ -1238,9 +1238,9 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_client = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_results = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET collation_connection = @@collation_database;</userinput>
+SET character_set_client = <replaceable>x</replaceable>;
+SET character_set_results = <replaceable>x</replaceable>;
+SET collation_connection = @@collation_database;
</programlisting>
<para>
@@ -1299,7 +1299,7 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_results = NULL;</userinput>
+SET character_set_results = NULL;
</programlisting>
<para>
@@ -1308,6 +1308,16 @@
NAMES 'ucs2'</literal> does not work.
</para>
+ <para>
+ To see the values of the character set and collation system
+ variables that apply to your connection, use these statements:
+ </para>
+
+<programlisting>
+SHOW VARIABLES LIKE 'character_set%';
+SHOW VARIABLES LIKE 'collation%';
+</programlisting>
+
</section>
<section id="charset-collations">
Modified: trunk/refman-5.0/charset.xml
===================================================================
--- trunk/refman-5.0/charset.xml 2006-02-01 16:47:00 UTC (rev 1168)
+++ trunk/refman-5.0/charset.xml 2006-02-01 18:44:04 UTC (rev 1169)
@@ -383,10 +383,10 @@
<para>
There are default settings for character sets and collations at
- four levels: server, database, table, and column. The
- following description may appear complex, but it has been found in
- practice that multiple-level defaulting leads to natural and
- obvious results.
+ four levels: server, database, table, and column. The following
+ description may appear complex, but it has been found in practice
+ that multiple-level defaulting leads to natural and obvious
+ results.
</para>
<para>
@@ -1209,9 +1209,9 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_client = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_results = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_connection = <replaceable>x</replaceable>;</userinput>
+SET character_set_client = <replaceable>x</replaceable>;
+SET character_set_results = <replaceable>x</replaceable>;
+SET character_set_connection = <replaceable>x</replaceable>;
</programlisting>
<para>
@@ -1230,9 +1230,9 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_client = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_results = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET collation_connection = @@collation_database;</userinput>
+SET character_set_client = <replaceable>x</replaceable>;
+SET character_set_results = <replaceable>x</replaceable>;
+SET collation_connection = @@collation_database;
</programlisting>
<para>
@@ -1291,7 +1291,7 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_results = NULL;</userinput>
+SET character_set_results = NULL;
</programlisting>
<para>
@@ -1300,6 +1300,16 @@
NAMES 'ucs2'</literal> does not work.
</para>
+ <para>
+ To see the values of the character set and collation system
+ variables that apply to your connection, use these statements:
+ </para>
+
+<programlisting>
+SHOW VARIABLES LIKE 'character_set%';
+SHOW VARIABLES LIKE 'collation%';
+</programlisting>
+
</section>
<section id="charset-collations">
Modified: trunk/refman-5.1/charset.xml
===================================================================
--- trunk/refman-5.1/charset.xml 2006-02-01 16:47:00 UTC (rev 1168)
+++ trunk/refman-5.1/charset.xml 2006-02-01 18:44:04 UTC (rev 1169)
@@ -383,10 +383,10 @@
<para>
There are default settings for character sets and collations at
- four levels: server, database, table, and column. The
- following description may appear complex, but it has been found in
- practice that multiple-level defaulting leads to natural and
- obvious results.
+ four levels: server, database, table, and column. The following
+ description may appear complex, but it has been found in practice
+ that multiple-level defaulting leads to natural and obvious
+ results.
</para>
<para>
@@ -1209,9 +1209,9 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_client = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_results = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_connection = <replaceable>x</replaceable>;</userinput>
+SET character_set_client = <replaceable>x</replaceable>;
+SET character_set_results = <replaceable>x</replaceable>;
+SET character_set_connection = <replaceable>x</replaceable>;
</programlisting>
<para>
@@ -1230,9 +1230,9 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_client = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET character_set_results = <replaceable>x</replaceable>;</userinput>
-mysql> <userinput>SET collation_connection = @@collation_database;</userinput>
+SET character_set_client = <replaceable>x</replaceable>;
+SET character_set_results = <replaceable>x</replaceable>;
+SET collation_connection = @@collation_database;
</programlisting>
<para>
@@ -1291,7 +1291,7 @@
</para>
<programlisting>
-mysql> <userinput>SET character_set_results = NULL;</userinput>
+SET character_set_results = NULL;
</programlisting>
<para>
@@ -1300,6 +1300,16 @@
NAMES 'ucs2'</literal> does not work.
</para>
+ <para>
+ To see the values of the character set and collation system
+ variables that apply to your connection, use these statements:
+ </para>
+
+<programlisting>
+SHOW VARIABLES LIKE 'character_set%';
+SHOW VARIABLES LIKE 'collation%';
+</programlisting>
+
</section>
<section id="charset-collations">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1169 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 1 Feb |
