Quoting Ilya Konstantinov, from the post of Wed, 14 Jun:
> Do the database / table definition statements within the dump specify
> the UTF-8 charset?
yup.
> Generally, the MySQL model is that there's a charset specified by the
> storage facility (for storage without any specification, the server's
> default charset is assumed, but that's a bad practice obviously) and a
well, I read the URLs you sent, and indeed SHOW VARIABLES
'character_set_%' showed that some were set to UTF-8 and some to latin1.
I set them all to utf8 and pulled up the dump with "source" rather than
redirect on the commandline, and hey-presto.
however these settings don't seem to keep their values over server
restarts, and only some of them are recognized in .my.conf. Any way to
make them permanent?
> charset requested by the client ("connection charset"). The server does
> the necessary conversions to bring the text from the storage charset to
> the client's preferred one. Thus, a decent client should specify its
> preferred charset with:
> SET NAMES ...
> SET CHARACTER SET ...
> ( http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html )
>
> If PhpMyAdmin is careless enough not to execute those statements, we can
> only hope it'll receive the right thing.
>
> >Is this an bug in MySQL 5 or is it something else I missed during the
> >import? Is the dump coming out of phpMyAdmin somehow incompatible with
> >my attempts to import it on the commandline?
> >
> In summary, MySQL, since version 4.1, has a very concise model for
> internationalization, as long as you play by the rules. Read more here:
> http://dev.mysql.com/doc/refman/5.0/en/charset.html
>
> =================================================================
> To unsubscribe, send mail to [EMAIL PROTECTED] with
> the word "unsubscribe" in the message body, e.g., run the command
> echo unsubscribe | mail [EMAIL PROTECTED]
>
--
America's top model
Ira Abramov
http://ira.abramov.org/email/
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
