SpirirHost Support Centre: MySQL Reference Manual p.420

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

420 MySQL Technical Reference for Version 4.0.3 LCASE(str) LOWER(str) Returns the string str with all characters changed to lowercase according to the current character set mapping (the default is ISO-8859-1 Latin1): mysql> SELECT LCASE('QUADRATICALLY'); -> 'quadratically' This function is multi-byte safe. UCASE(str) UPPER(str) Returns the string str with all characters changed to uppercase according to the current character set mapping (the default is ISO-8859-1 Latin1): mysql> SELECT UCASE('Hej'); -> 'HEJ' This function is multi-byte safe. LOAD_FILE(file_name) Reads the le and returns the le contents as a string. The le must be on the server, you must specify the full pathname to the le, and you must have the FILE privilege. The le must be readable by all and be smaller than max_ allowed_packet. If the le doesn't exist or can't be read due to one of the above reasons, the function returns NULL: mysql> UPDATE tbl_name SET blob_column=LOAD_FILE("/tmp/picture") WHERE id=1; If you are not using MySQL Version 3.23, you have to do the reading of the le inside your application and create an INSERT statement to update the database with the le information. One way to do this, if you are using the MySQL++ library, can be found at http://www.mysql.com/documentation/mysql++/mysql++-examples.html. MySQL automatically converts numbers to strings as necessary, and vice-versa: mysql> SELECT 1+"1"; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' If you want to convert a number to a string explicitly, pass it as the argument to CONCAT(). If a string function is given a binary string as an argument, the resulting string is also a binary string. A number converted to a string is treated as a binary string. This only aects comparisons. 6.3.2.1 String Comparison Functions Normally, if any expression in a string comparison is case-sensitive, the comparison is per- formed in case-sensitive fashion.

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide