I have a strange, irritating problem that I think is to do with MySQL. I have a table on a live (shared hosting) system that, when I use it on my local system, seems to wind up in utf-8 rather than latin1. Here's the set-up:
Live system - MySQL 3.2.3.56, PHP 4.1.2, Apache 1.3.27. MySQL is configured to use latin1, PHP to no default charset. Local system - MySQL 4.0.18-32, PHP 4.3.4, Apache2 (all from SuSE 9.1 distro). MySQL is configured to use latin1, PHP to no default charset. I have a table containing text with French accented characters. On the live system, these display correctly when viewed with a browser set to iso-8859-1 encoding (which is what the page specifies). On the local system, the page has to be viewed as utf-8. Huh? This is the same data. I dumped the table from the live system (via phpMyAdmin - also set to use latin1) to my local disk. I viewed that with Kwrite which showed me that the text was, indeed, latin1 in that file. I uploaded the table to the local system. In MySQLcc (set to latin1) the text reads correctly. Running myisamchk on the table tells me it's latin1. And yet, if I mysqldump the table, the resulting file appears to be utf-8! And data pulled from the table by PHP also appears to be utf-8. Help! @+ Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
