Hello.
What charset produced mysqldump with --default-character-set=latin1 command line option? Steve Mansfield <[EMAIL PROTECTED]> wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
