Skip to content

Instantly share code, notes, and snippets.

@knowuh
Created May 7, 2012 20:38
Show Gist options
  • Save knowuh/2630243 to your computer and use it in GitHub Desktop.
Save knowuh/2630243 to your computer and use it in GitHub Desktop.
Mysql variables set on seymour (May 7)
SHOW VARIABLES LIKE 'character\_set\_%';
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
+--------------------------+--------+
7 rows in set (0.00 sec)
(In a rails console:)
irb(main):004:0> User.first.first_name.encoding
=> #<Encoding:ASCII-8BIT>
irb(main):005:0> "thing".encoding
=> #<Encoding:UTF-8>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment