[Rails] Best way to set database connection collation in rails?
Hello, I want to change the connection collation that rails uses but I'm unsure of exactly what the best way to do this is. Everything in MySQL - the server, database and all tables are set to utf8_unicode_ci collation, but the connection collation in rails still appears to be utf8_general_ci (the default?). We are using the mysql2 adapter.
I've seen a couple of possible methods:
Set the collation to utf8_unicode_ci via an init-connect line in the database server's my.cnf
Set the ActiveRecord ConnectionAdapter to use the desired collation.
Is there a best approach?
Alternately, how much does it matter if the connection collation doesn't match set in the database server?
Thanks,
~ Alex
-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/544afb14-2ec5-4fbd-8323-5501614a614e%40googlegroups.com?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home