Re: Encoding problem...

[Rick James]

"view it using 'latin 1' encoding, 'ç' is displayed as 'ç'. Does this mean it 2 bytes in the dump? " -- This pretty much means that your c-cedilla is encoded in UTF8 (as you want). The latin1 A-tilde is the first byte of most Western European utf8 characters.

So, most of your parts are correctly talking utf8 --
* CREATE TABLE...DEFAULT CHARSET=utf8; -- correct.
* Browser -- Well even if you don't have the correct <meta...>, it is usually guessing right for you.
* Client(s) -- Here is where things may be going wrong. In particular, the "remote server" is partially wrong.
* CREATE DATABASE `times_dbDixon` /*!40100 DEFAULT CHARACTER SET latin1 */ -- not critical, since the TABLE overrides it.
* mysqldump /*!40101 SET NAMES utf8 */; -- good. This sets 3 character_set% VARIABLES.