[thelist] character encoding nightmare
hassan.schroeder at gmail.com
Fri Mar 17 17:42:39 UTC 2017
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
Consulting Availability : Silicon Valley or remote
More information about the thelist