[thelist] character encoding nightmare

[Hassan Schroeder]

On Thu, Mar 16, 2017 at 4:02 PM, Garth Hagerman <hagerman at mcn.org> wrote:

> I’ve got two MySQL databases running on different hosts. I’ve written a series of scripts which keep certain tables and fields synced between them.
> The basic mechanics of this work fine, but certain characters turn to gibberish on the second site.

The first thing to ask is: are the 2 instances of MySQL running the
*exact* same version with the *exact* same config, at least as it
relates to character encoding/collation? And are the clients doing
the inserts configured identically encoding-wise?

-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote