MySQL - Sending Non-ASCII Text to MySQL

∟MySQL - Sending Non-ASCII Text to MySQL

This chapter provides tutorial notes on sending non-ASCII text data to MySQL. Topics include sending non-ASCII text data in SQL statements; changing MySQL character set settings to send Latin1, UTF-8, BGK, and Big5 characters.

These sections are omitted from this Web preview version. To view the full content, see information on how to obtain the full version this book.

Sending Non-ASCII Text to MySQL in Latin1 Encoding

Sending Non-ASCII Text to MySQL in UTF8 Encoding

Sending Non-ASCII Text to MySQL in GBK Encoding

Sending Non-ASCII Text to MySQL in Big5 Encoding

Sending Non-ASCII Text to MySQL in Multiple Encoding

Summary - Sending and Fetching Non-ASCII Text

Takeaways:

MySQL 8 uses UTF-8 as the default character set (encoding) for all tables.
MYSQL uses "character_set_client" and "character_set_connection" session variables to control encoding conversion when sending data to database.
If your database column uses a character set different than the "character_set_client" and "character_set_connection" session variables, your data will be converted by MySQL Server when sending it to the database to store.
MySQL 8 rejects invalid encoding data to be stored in database columns.
PHP 7 MySQL extension sets "character_set_client" and "character_set_connection"" to UTF-8 by default.
Use UTF-8 as the single character set (encoding) for all database columns and set encoding to UTF-8 everywhere will avoid a lots of trouble.
MySQL 5 uses Latin1 as the default character set for all tables.
PHP 5 MySQL extension sets "character_set_client" and "character_set_connection" to Latin1 by default.
MySQL 5 allows invalid encoding data to be stored in database columns.

Table of Contents

About This Book

PHP Installation on Windows Systems

Integrating PHP with Apache Web Server

charset="*" - Encodings on Chinese Web Pages

Chinese Characters in PHP String Literals

Multibyte String Functions in UTF-8 Encoding

Input Text Data from Web Forms

Input Chinese Text Data from Web Forms

MySQL - Installation on Windows

MySQL - Connecting PHP to Database

MySQL - Character Set and Encoding

►MySQL - Sending Non-ASCII Text to MySQL

Retrieving Chinese Text from Database to Web Pages

Input Chinese Text Data to MySQL Database

Chinese Text Encoding Conversion and Corruptions

Archived Tutorials

References

Full Version in PDF/EPUB