Unable to copy data from one SQL table to another
I've had an ongoing project for a while in where I had to grab data from an API and make use of it. The data needed to be stored for historical reference, but due to specific requests by the person I was making it for, I stored the data as the resulting XML (eg, in a text column). That XML was read when needed and parsed as needed.
Obviously though, this is far from efficient, plus added a lot more data then was necessary.
Finally, the project is under new management and I'm looking to convert all the stored XML data into individual columns. I wrote up a script that would pull the XML, read it, and then break it up as appropriate, no problems.
The only issue I had is that some of the data are Greek characters, which read just fine from the XML data, but when I try to insert them into their new destinations, don't store properly, and I have no idea why. I can read the data from the XML, it displays properly when echo'ed, but when I try to then insert the same data it displays, it shows up the same in phpMyAdmin but shows up malformed when I select/echo it back out.
So at this point, I'm not sure if this is a PHP or MySQL issue. The only difference between the two tables is that one is MyISAM and the other InnoDB, which I don't think should make a difference here. Otherwise, I can only imagine there's some issue I am unaware of that I need to to do to get the characters to copy properly.