This section provides a test on sending non-ASCII character strings to MySQL server in multiple encoding.

As you can see from previous tests, when character_set_client and character_set_connection are set to a specific encoding,
MySQL expects you to send non-ASCII text data with that encoding.

If you have a table of multiple columns with different encodings, you can not included non-ASCII text data for all columns
in a single SQL INSERT statement and expect MySQL to handle it correctly on all columns.
One way to solve this problem is to send non-ASCII text with multiple SQL UPDATE statements: one for each column.
Before each UPDATE statement, reset character_set_client and character_set_connection to match the encoding of the next statement.

What I did in the next PHP script is to break the INSERT statement into multiple UPDATE statements.
Each UPDATE statement sends non-ASCII text data only for one column with proper settings.