[thelist] character encoding nightmare

Anthony Baratta anthony at baratta.com
Thu Mar 16 23:08:59 UTC 2017

How are you copying data from DB 1 to DB 2 or are you sending data to both at the same time via the same script? Either way, How are you escaping / making the data safe for insertion into the DB?

Anthony Baratta
-----Original Message----- 
> From: "Garth Hagerman" <hagerman at mcn.org> 
> To: thelist at lists.evolt.org 
> Date: 03/16/17 16:04 
> Subject: [thelist] character encoding nightmare 
> Hello-
> Is The List still alive?
> I’ve got a problem which would probably be simple to solve if I knew more about character encoding, but, since I don’t, I’ve been flailing wildly and wasting a lot of time.
> I’ll give you the short version. If somebody replies, I can supply further details.
> 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 exact same html enity-ized strings are being inserted into both DBs, but apostrophes, etc. turn to gibberish on the second site.
> Originally, I had everything with the sites’ pages using iso-8859-1encoding and the DBs set for Latin-Swedish collation. As I read about encoding problems, it was suggested I convert to UTF-8. That makes things worse.
> I really don’t know what to try.
>   thanks in advance
>  Garth
> -- 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

More information about the thelist mailing list