acts-as-taggable-on icon indicating copy to clipboard operation
acts-as-taggable-on copied to clipboard

Do not apply binary collation every time on rails boot for MySQL users

Open shawnali63 opened this issue 5 years ago • 2 comments
trafficstars

Fixes #905

Background: To fix collation issue with MySQL we added ActsAsTaggableOn.force_binary_collation = true

Reason: With force_binary_collation = true option we execute following script every time on rails boot which is trying to update database which is not yet available.

ActiveRecord::Migration.execute("ALTER TABLE tags MODIFY name varchar(255) CHARACTER SET utf8 COLLATE utf8_bin;")

This script should be executed only once not every time when rails is booted. User must set collation by re-running migration generator or run this rake task:

rake acts_as_taggable_on_engine:tag_names:collate_bin

shawnali63 avatar Nov 21 '19 09:11 shawnali63

I wish this would get merged, the ALTER TABLE statements executed every boot is anoying.

matthewhively avatar Dec 02 '20 23:12 matthewhively

Hey guys, is there an ETA for when this would get merged in? thanks

skaidra-bake avatar Apr 02 '21 13:04 skaidra-bake