<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • 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
    268 MySQL Technical Reference for Version 4.0.3 You can change the character set with the --default-character-set option when you start the server.  The character sets available depend on the  --with-charset=charset  and  -- with-extra-charset= list-of-charset | complex | all  options to  configure, and the character  set  con guration   les  listed  in  `SHAREDIR/charsets/Index'.   See  Section  2.3.3 [con gure options], page 83. If  you  change  the  character  set  when  running  MySQL  (which  may  also  change  the  sort order), you must run myisamchk -r -q on all tables.  Otherwise, your indexes may not be ordered correctly. When a client connects to a MySQL server, the server sends the default character set in use to the client.  The client will switch to use this character set for this connection. One  should  use  mysql_real_escape_string()  when  escaping  strings  for  a  SQL  query. mysql_real_escape_string()  is  identical  to  the  old  mysql_escape_string()  function, except that it takes the MYSQL connection handle as the rst parameter. If the client is compiled with di erent paths than where the server is installed and the user who con gured MySQL didn't include all character sets in the MySQL binary, one must specify for the client where it can nd the additional character sets it will need if the server runs with a di erent character set than the client. One can specify this by putting in a MySQL option le: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets where  the  path  points  to  the  directory  in  which  the  dynamic  MySQL  character  sets  are stored. One can force the client to use speci c character set by specifying: [client] default-character-set=character-set-name but normally this is never needed. 4.6.1.1  German character set To  get  German  sorting  order,   you  should  start  mysqld  with  --default-character- set=latin_de.  This will give you the following characteristics. When sorting and comparing string's the following mapping is done on the strings before doing the comparison: ->   ae ->   oe ->   ue ->   ss All  accented  characters,  are  converted  to  their  un-accented  uppercase  counterpart.   All letters are converted to uppercase. When  comparing  strings  with  LIKE  the  one  ->  two  character  mapping  is  not  done.   All letters are converted to uppercase.  Accent are removed from all letters except:  , , , ,  and .
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    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