| List: | Commits | « Previous MessageNext Message » | |
| From: | paul | Date: | May 17 2008 4:55pm |
| Subject: | svn commit - mysqldoc@docsrva: r10765 - in trunk: . it/refman-5.1 pt/refman-5.1 refman-4.1 refman-5.0 refman-5.1 refman-6.0 | ||
| View as plain text | |||
Author: paul Date: 2008-05-17 16:55:44 +0200 (Sat, 17 May 2008) New Revision: 10765 Log: r31465@frost: paul | 2008-05-16 19:27:33 -0500 Show how to make LOWER()/UPPER() perform lettercase conversion of binary strings. Modified: trunk/it/refman-5.1/functions-core.xml trunk/pt/refman-5.1/functions-core.xml trunk/refman-4.1/functions-core.xml trunk/refman-5.0/functions-core.xml trunk/refman-5.1/functions-core.xml trunk/refman-6.0/functions-core.xml Property changes on: trunk ___________________________________________________________________ Name: svk:merge - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31436 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31325 + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31465 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31325 Modified: trunk/it/refman-5.1/functions-core.xml =================================================================== --- trunk/it/refman-5.1/functions-core.xml 2008-05-16 20:03:08 UTC (rev 10764) +++ trunk/it/refman-5.1/functions-core.xml 2008-05-17 14:55:44 UTC (rev 10765) Changed blocks: 2, Lines Added: 31, Lines Deleted: 8; 2370 bytes @@ -3107,16 +3107,33 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT LOWER('QUADRATICALLY');</userinput> -> 'quadratically' </programlisting> <para> + <function role="sql">LOWER()</function> (and + <function role="sql">UPPER()</function>) are ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). To + perform lettercase conversion, convert the string to a + non-binary string: + </para> + +<programlisting> +mysql> <userinput>SET @str = BINARY 'New York';</userinput> +mysql> <userinput>SELECT LOWER(@str), LOWER(CONVERT(@str USING latin1));</userinput> ++-------------+-----------------------------------+ +| LOWER(@str) | LOWER(CONVERT(@str USING latin1)) | ++-------------+-----------------------------------+ +| New York | new york | ++-------------+-----------------------------------+ +</programlisting> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> @@ -4125,16 +4142,22 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT UPPER('Hej');</userinput> -> 'HEJ' </programlisting> <para> + <function role="sql">UPPER()</function> is ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). The + description of <function role="sql">LOWER()</function> shows + how to perform lettercase conversion of binary strings. + </para> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> Modified: trunk/pt/refman-5.1/functions-core.xml =================================================================== --- trunk/pt/refman-5.1/functions-core.xml 2008-05-16 20:03:08 UTC (rev 10764) +++ trunk/pt/refman-5.1/functions-core.xml 2008-05-17 14:55:44 UTC (rev 10765) Changed blocks: 2, Lines Added: 31, Lines Deleted: 8; 2370 bytes @@ -3107,16 +3107,33 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT LOWER('QUADRATICALLY');</userinput> -> 'quadratically' </programlisting> <para> + <function role="sql">LOWER()</function> (and + <function role="sql">UPPER()</function>) are ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). To + perform lettercase conversion, convert the string to a + non-binary string: + </para> + +<programlisting> +mysql> <userinput>SET @str = BINARY 'New York';</userinput> +mysql> <userinput>SELECT LOWER(@str), LOWER(CONVERT(@str USING latin1));</userinput> ++-------------+-----------------------------------+ +| LOWER(@str) | LOWER(CONVERT(@str USING latin1)) | ++-------------+-----------------------------------+ +| New York | new york | ++-------------+-----------------------------------+ +</programlisting> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> @@ -4125,16 +4142,22 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT UPPER('Hej');</userinput> -> 'HEJ' </programlisting> <para> + <function role="sql">UPPER()</function> is ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). The + description of <function role="sql">LOWER()</function> shows + how to perform lettercase conversion of binary strings. + </para> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> Modified: trunk/refman-4.1/functions-core.xml =================================================================== --- trunk/refman-4.1/functions-core.xml 2008-05-16 20:03:08 UTC (rev 10764) +++ trunk/refman-4.1/functions-core.xml 2008-05-17 14:55:44 UTC (rev 10765) Changed blocks: 2, Lines Added: 31, Lines Deleted: 8; 2361 bytes @@ -2997,16 +2997,33 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT LOWER('QUADRATICALLY');</userinput> -> 'quadratically' </programlisting> <para> + <function role="sql">LOWER()</function> (and + <function role="sql">UPPER()</function>) are ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). To + perform lettercase conversion, convert the string to a + non-binary string: + </para> + +<programlisting> +mysql> <userinput>SET @str = BINARY 'New York';</userinput> +mysql> <userinput>SELECT LOWER(@str), LOWER(CONVERT(@str USING latin1));</userinput> ++-------------+-----------------------------------+ +| LOWER(@str) | LOWER(CONVERT(@str USING latin1)) | ++-------------+-----------------------------------+ +| New York | new york | ++-------------+-----------------------------------+ +</programlisting> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> @@ -4021,16 +4038,22 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT UPPER('Hej');</userinput> -> 'HEJ' </programlisting> <para> + <function role="sql">UPPER()</function> is ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). The + description of <function role="sql">LOWER()</function> shows + how to perform lettercase conversion of binary strings. + </para> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> Modified: trunk/refman-5.0/functions-core.xml =================================================================== --- trunk/refman-5.0/functions-core.xml 2008-05-16 20:03:08 UTC (rev 10764) +++ trunk/refman-5.0/functions-core.xml 2008-05-17 14:55:44 UTC (rev 10765) Changed blocks: 2, Lines Added: 31, Lines Deleted: 8; 2361 bytes @@ -3139,16 +3139,33 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT LOWER('QUADRATICALLY');</userinput> -> 'quadratically' </programlisting> <para> + <function role="sql">LOWER()</function> (and + <function role="sql">UPPER()</function>) are ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). To + perform lettercase conversion, convert the string to a + non-binary string: + </para> + +<programlisting> +mysql> <userinput>SET @str = BINARY 'New York';</userinput> +mysql> <userinput>SELECT LOWER(@str), LOWER(CONVERT(@str USING latin1));</userinput> ++-------------+-----------------------------------+ +| LOWER(@str) | LOWER(CONVERT(@str USING latin1)) | ++-------------+-----------------------------------+ +| New York | new york | ++-------------+-----------------------------------+ +</programlisting> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> @@ -4194,16 +4211,22 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT UPPER('Hej');</userinput> -> 'HEJ' </programlisting> <para> + <function role="sql">UPPER()</function> is ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). The + description of <function role="sql">LOWER()</function> shows + how to perform lettercase conversion of binary strings. + </para> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> Modified: trunk/refman-5.1/functions-core.xml =================================================================== --- trunk/refman-5.1/functions-core.xml 2008-05-16 20:03:08 UTC (rev 10764) +++ trunk/refman-5.1/functions-core.xml 2008-05-17 14:55:44 UTC (rev 10765) Changed blocks: 2, Lines Added: 31, Lines Deleted: 8; 2361 bytes @@ -3107,16 +3107,33 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT LOWER('QUADRATICALLY');</userinput> -> 'quadratically' </programlisting> <para> + <function role="sql">LOWER()</function> (and + <function role="sql">UPPER()</function>) are ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). To + perform lettercase conversion, convert the string to a + non-binary string: + </para> + +<programlisting> +mysql> <userinput>SET @str = BINARY 'New York';</userinput> +mysql> <userinput>SELECT LOWER(@str), LOWER(CONVERT(@str USING latin1));</userinput> ++-------------+-----------------------------------+ +| LOWER(@str) | LOWER(CONVERT(@str USING latin1)) | ++-------------+-----------------------------------+ +| New York | new york | ++-------------+-----------------------------------+ +</programlisting> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> @@ -4125,16 +4142,22 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT UPPER('Hej');</userinput> -> 'HEJ' </programlisting> <para> + <function role="sql">UPPER()</function> is ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). The + description of <function role="sql">LOWER()</function> shows + how to perform lettercase conversion of binary strings. + </para> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> Modified: trunk/refman-6.0/functions-core.xml =================================================================== --- trunk/refman-6.0/functions-core.xml 2008-05-16 20:03:08 UTC (rev 10764) +++ trunk/refman-6.0/functions-core.xml 2008-05-17 14:55:44 UTC (rev 10765) Changed blocks: 2, Lines Added: 31, Lines Deleted: 8; 2361 bytes @@ -3207,16 +3207,33 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT LOWER('QUADRATICALLY');</userinput> -> 'quadratically' </programlisting> <para> + <function role="sql">LOWER()</function> (and + <function role="sql">UPPER()</function>) are ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). To + perform lettercase conversion, convert the string to a + non-binary string: + </para> + +<programlisting> +mysql> <userinput>SET @str = BINARY 'New York';</userinput> +mysql> <userinput>SELECT LOWER(@str), LOWER(CONVERT(@str USING latin1));</userinput> ++-------------+-----------------------------------+ +| LOWER(@str) | LOWER(CONVERT(@str USING latin1)) | ++-------------+-----------------------------------+ +| New York | new york | ++-------------+-----------------------------------+ +</programlisting> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem> @@ -4225,16 +4242,22 @@ <literal>latin1</literal> (cp1252 West European). </para> - <remark role="help-description-end"/> - - <remark role="help-example"/> - <programlisting> mysql> <userinput>SELECT UPPER('Hej');</userinput> -> 'HEJ' </programlisting> <para> + <function role="sql">UPPER()</function> is ineffective when + applied to binary strings (<literal>BINARY</literal>, + <literal>VARBINARY</literal>, <literal>BLOB</literal>). The + description of <function role="sql">LOWER()</function> shows + how to perform lettercase conversion of binary strings. + </para> + + <remark role="help-description-end"/> + + <para> This function is multi-byte safe. </para> </listitem>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r10765 - in trunk: . it/refman-5.1 pt/refman-5.1 refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 17 May |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.496 sec. using MySQL 5.1.14-beta-log