:: DEVELOPER ZONE
MySQL Reference Manual :: A.2.16 Can't initialize character set
Search the MySQL manual:
- A.2 Common Errors When Using MySQL Programs
- A.2.1 Access denied
- A.2.2 Can't connect to [local] MySQL server
- A.2.3 Client does not support authentication protocol
- A.2.4 Password Fails When Entered Interactively
- A.2.5 Host 'host_name' is blocked
- A.2.6 Too many connections
- A.2.7 Out of memory
- A.2.8 MySQL server has gone away
- A.2.9 Packet too large
- A.2.10 Communication Errors and Aborted Connections
- A.2.11 The table is full
- A.2.12 Can't create/write to file
- A.2.13 Commands out of sync
- A.2.14 Ignoring user
- A.2.15 Table 'tbl_name' doesn't exist
- A.2.16 Can't initialize character set
- A.2.17 File Not Found
Additional languages
Additional formats
You might see an error like this if you have character set problems:
MySQL Connection Failed: Can't initialize character set charset_name
This error can have any of the following causes:
-
The character set is a multi-byte character set and you have no support for the character set in the client. In this case, you need to recompile the client by running configure with the
--with-charset=orcharset_name--with-extra-charsets=option. See Section 2.8.2, “Typical configure Options”.charset_nameAll standard MySQL binaries are compiled with
--with-extra-character-sets=complex, which enables support for all multi-byte character sets. See Section 5.9.1, “The Character Set Used for Data and Sorting”. -
The character set is a simple character set that is not compiled into mysqld, and the character set definition files are not in the place where the client expects to find them.
In this case, you need to use one of the following methods to solve the problem:
Recompile the client with support for the character set. See Section 2.8.2, “Typical configure Options”.
Specify to the client the directory where the character set definition files are located. For many clients, you can do this with the
--character-sets-diroption.Copy the character definition files to the path where the client expects them to be.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.