Managing Non-ASCII Character Strings with MySQL Servers
This chapter provides tutorial examples and notes about handling non-ASCII characters with MySQL server. Topics include storing non-ASCII characters in MySQL database with various character set encodings; managing encoding conversion when inserting data to and retrieving data from database; examples on using UTF-8 encoding.
Storing Non-ASCII Characters in Database
Transmitting Non-ASCII Characters with Database
MySqlUnicode.php - MySQL Unicode UTF-8 Encoding Example
- MySQL provides a good support on non-ASCII characters. If offers a number of encodings (character sets).
- MySQL allows us to specify encodings at database, table or column level.
- MySQL allows us to control encoding conversions on receiving SQL statements and returning query results.
- My recommendation is to use UTF-8 to all text information, turn off MySQL encoding conversion on receiving
SQL statements and returning query results, and let your PHP script to handle UTF-8 strings.
Table of Contents
About This Book
Introduction and Installation of PHP 7.0
PHP Script File Syntax
PHP Data Types and Data Literals
Variables, References, and Constants
Expressions, Operations and Type Conversions
Conditional Statements - "if" and "switch"
Loop Statements - "while", "for", and "do ... while"
Function Declaration, Arguments, and Return Values
Arrays - Ordered Maps
Configuring and Sending out Emails
Retrieving Information from HTTP Requests
Creating and Managing Sessions in PHP Scripts
Sending and Receiving Cookies in PHP Scripts
Controlling HTTP Response Header Lines in PHP Scripts
MySQL Server Connection and Access Functions
Functions to Manage Directories, Files and Images
SOAP Extension Function and Calling Web Services
SOAP Server Functions and Examples
Localization Overview of Web Applications
Using Non-ASCII Characters in HTML Documents
Using Non-ASCII Characters as PHP Script String Literals
Receiving Non-ASCII Characters from Input Forms
"mbstring" Extension and Non-ASCII Encoding Management
►Managing Non-ASCII Character Strings with MySQL Servers
Introduction of Class and Object
Integrating PHP with Apache Web Server
PDF Printing Version