Contact MySQL
|
Login
|
Register
The world's most popular open source database
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
Router
Utilities/Fabric
Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 5.6 Reference Manual
Preface and Legal Notices
General Information
Installing and Upgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Globalization
Character Set Support
Character Sets and Collations in General
Character Sets and Collations in MySQL
Collation Naming Conventions
Specifying Character Sets and Collations
Server Character Set and Collation
Database Character Set and Collation
Table Character Set and Collation
Column Character Set and Collation
Character String Literal Character Set and Collation
National Character Set
Examples of Character Set and Collation Assignment
Compatibility with Other DBMSs
Connection Character Sets and Collations
Configuring the Character Set and Collation for Applications
Character Set for Error Messages
Collation Issues
Using COLLATE in SQL Statements
COLLATE Clause Precedence
Collations Must Be for the Right Character Set
Collation of Expressions
The _bin and binary Collations
The BINARY Operator
Examples of the Effect of Collation
Collation and INFORMATION_SCHEMA Searches
String Repertoire
Operations Affected by Character Set Support
Result Strings
CONVERT() and CAST()
SHOW Statements and INFORMATION_SCHEMA
Unicode Support
The ucs2 Character Set (UCS-2 Unicode Encoding)
The utf16 Character Set (UTF-16 Unicode Encoding)
The utf16le Character Set (UTF-16LE Unicode Encoding)
The utf32 Character Set (UTF-32 Unicode Encoding)
The utf8 Character Set (3-Byte UTF-8 Unicode Encoding)
The utf8mb3 Character Set (Alias for utf8)
The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)
Upgrading from Previous to Current Unicode Support
UTF-8 for Metadata
Column Character Set Conversion
Character Sets and Collations Supported by MySQL
Unicode Character Sets
West European Character Sets
Central European Character Sets
South European and Middle East Character Sets
Baltic Character Sets
Cyrillic Character Sets
Asian Character Sets
Setting the Error Message Language
Adding a Character Set
Character Definition Arrays
String Collating Support for Complex Character Sets
Multi-Byte Character Support for Complex Character Sets
Adding a Collation to a Character Set
Collation Implementation Types
Choosing a Collation ID
Adding a Simple Collation to an 8-Bit Character Set
Adding a UCA Collation to a Unicode Character Set
Defining a UCA Collation Using LDML Syntax
LDML Syntax Supported in MySQL
Diagnostics During Index.xml Parsing
Character Set Configuration
MySQL Server Time Zone Support
Staying Current with Time Zone Changes
Time Zone Leap Second Support
MySQL Server Locale Support
Data Types
Functions and Operators
SQL Statement Syntax
The InnoDB Storage Engine
Alternative Storage Engines
High Availability and Scalability
Replication
MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4
Partitioning
Stored Programs and Views
INFORMATION_SCHEMA Tables
MySQL Performance Schema
Connectors and APIs
Extending MySQL
MySQL Enterprise Edition
MySQL Workbench
MySQL 5.6 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
MySQL Glossary
General Index
Function Index
Command Index
Function Index
INFORMATION_SCHEMA Index
Join Types Index
Operator Index
Option Index
Privileges Index
Modes Index
Statement/Syntax Index
Status Variable Index
System Variable Index
Transaction Isolation Level Index
Related Documentation
MySQL 5.6 Release Notes
Download this Manual
PDF (US Ltr)
- 31.4Mb
PDF (A4)
- 31.6Mb
PDF (RPM)
- 30.1Mb
EPUB
- 7.7Mb
HTML Download (TGZ)
- 7.5Mb
HTML Download (Zip)
- 7.5Mb
HTML Download (RPM)
- 6.5Mb
Eclipse Doc Plugin (TGZ)
- 8.2Mb
Eclipse Doc Plugin (Zip)
- 10.1Mb
Man Pages (TGZ)
- 181.2Kb
Man Pages (Zip)
- 292.4Kb
Info (Gzip)
- 2.8Mb
Info (Zip)
- 2.8Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL Cluster NDB 7.3-7.4
version 5.6
5.7 current
5.5
5.1
5.0
5.6 Japanese
MySQL 5.6 Reference Manual
/
...
/
Globalization
/
Character Set Support
/
Operations Affected by Character Set Support
10.1.10 Operations Affected by Character Set Support
[
+/-
]
10.1.10.1 Result Strings
10.1.10.2 CONVERT() and CAST()
10.1.10.3 SHOW Statements and INFORMATION_SCHEMA
This section describes operations that take character set information into account.
PREV
HOME
UP
NEXT
Related Documentation
MySQL 5.6 Release Notes
Download this Manual
PDF (US Ltr)
- 31.4Mb
PDF (A4)
- 31.6Mb
PDF (RPM)
- 30.1Mb
EPUB
- 7.7Mb
HTML Download (TGZ)
- 7.5Mb
HTML Download (Zip)
- 7.5Mb
HTML Download (RPM)
- 6.5Mb
Eclipse Doc Plugin (TGZ)
- 8.2Mb
Eclipse Doc Plugin (Zip)
- 10.1Mb
Man Pages (TGZ)
- 181.2Kb
Man Pages (Zip)
- 292.4Kb
Info (Gzip)
- 2.8Mb
Info (Zip)
- 2.8Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL Cluster NDB 7.3-7.4
User Comments
Posted by
Mike H
on April 26, 2010
LOAD DATA INFILE is also affected by character sets.
Sign Up
Login
You must be logged in to post a comment.