StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Included <code>skip-character-set-client-handshake</code> in the [mysqld] group of the my.cnf file and everything seems correctly configured, UTF8 straight through. I'm still not sure why <code>default-character-set=utf8</code> in the <code>[client]</code> group didn't take here, but I'm a newbie so hopefully someone can shed light there. You must create my.cnf in Applications/MAMP/conf and IN MAMP Pro, you go under the File > Edit Template > MySQL my.cnf to make the changes. </p> <p>my.cnf:</p> <pre><code># The MySQL server [mysqld] skip-character-set-client-handshake collation_server=utf8_unicode_ci character_set_server=utf8 </code></pre> <p>Results:</p> <pre><code>mysql> SHOW VARIABLES WHERE variable_name LIKE '%char%' OR variable_name LIKE '%colla%'; +--------------------------+--------------------------------------------+ | Variable_name | Value | +--------------------------+--------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /Applications/MAMP/Library/share/charsets/ | | collation_connection | utf8_unicode_ci | | collation_database | utf8_unicode_ci | | collation_server | utf8_unicode_ci | +--------------------------+--------------------------------------------+ </code></pre> <p>This also solved why mysqladmin's variables were different than mysql's when using <code>SHOW VARIABLES</code> for each. </p> <p>Solution mentioned in comments of MySQL manual <a href="http://dev.mysql.com/doc/refman/5.0/en/charset-server.html" rel="nofollow">here</a>.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload