I’m having some issues with trying to pull some information out of a mySQL database that has a latin1 character set but somehow manages to retain foreign characters. In PHPMyAdmin they show up as messed up text, but at least it’s something. However, when pulling this onto a PHP script I wrote, it will pull question marks to replace the characters that are not ASCII. I am trying to figure out how to edit the query so that it will not return question marks since CONVERT() and CAST() are not working.
