Wednesday, June 12, 2013

[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


Real Estate