Retrieving Chinese Text from Database to Web Pages

∟Retrieving Chinese Text from Database to Web Pages

This chapter provides tutorial notes on fetching Chinese text data from MySQL database and sending it to Web pages. Topics include a summary on retrieving text from MySQL database; tests on retrieving Chinese text in UTF-8, GBK and Big5 encodings.

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.

Retrieving Chinese Text from Database to Web Pages

Steps and Application Components Involved

Fetching ASCII Text from Database to Web

Fetching Chinese Text from Database to Web

Fetching Chinese Text from Database to Web in UTF-8

Fetching Chinese Text from Database to Web in GBK

Fetching Chinese Text from Database to Web in Big5

Summary - Fetching Chinese Text from Database to Web

Takeaways:

When retrieving data from MySQL 8 database with PHP 7 script to display as a Web page, all encodings are converted to UTF-8 by default.
When retrieving data from MySQL 5 database with PHP 5 script to display as a Web page, all encodings are converted to Latin1 by default.
To change MySQL and PHP encoding conversion behavior, you need to set the MySQL session "character_set_results" variable, the "Content-Type: charset=..." setting in the HTML document and the HTTP response header.

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