SpirirHost Support Centre: MySQL Reference Manual p.269

<< 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

Chapter 4: Database Administration 269 4.6.2 Non-English Error Messages mysqld can issue error messages in the following languages: Czech, Danish, Dutch, English (the default), Estonian, French, German, Greek, Hungarian, Italian, Japanese, Korean, Norwegian, Norwegian-ny, Polish, Portuguese, Romanian, Russian, Slovak, Spanish, and Swedish. To start mysqld with a particular language, use either the --language=lang or -L lang options. For example: shell> mysqld --language=swedish or: shell> mysqld --language=/usr/local/share/swedish Note that all language names are specied in lowercase. The language les are located (by default) in `mysql base dir/share/LANGUAGE/'. To update the error message le, you should edit the `errmsg.txt' le and execute the following command to generate the `errmsg.sys' le: shell> comp_err errmsg.txt errmsg.sys If you upgrade to a newer version of MySQL, remember to repeat your changes with the new `errmsg.txt' le. 4.6.3 Adding a New Character Set To add another character set to MySQL, use the following procedure. Decide if the set is simple or complex. If the character set does not need to use special string collating routines for sorting and does not need multi-byte character support, it is simple. If it needs either of those features, it is complex. For example, latin1 and danish are simple charactersets while big5 or czech are complex character sets. In the following section, we have assumed that you name your character set MYSET. For a simple character set do the following: 1. Add MYSET to the end of the `sql/share/charsets/Index' le Assign an unique number to it. 2. Create the le `sql/share/charsets/MYSET.conf'. (You can use `sql/share/charsets/latin1 as a base for this.) The syntax for the le very simple: Comments start with a '#' character and proceed to the end of the line. Words are separated by arbitrary amounts of whitespace. When dening the character set, every word must be a number in hexadecimal format The ctype array takes up the rst 257 words. The to_lower, to_upper and sort_order arrays take up 256 words each after that.

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