Tool database migration issue with Ruby 2.5.8

[MrSozuduz]

Hello, I have observed that the database creation when running ght-retrieve-repo hasn't been working properly due to an error during migration.

Character set 'binary' cannot be used in conjunction with 'utf8_general_ci' in call to regexp_like. /usr/share/rvm/gems/ruby-2.5.8/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in _query'`

After not being successful at creating the database, any subsequent run of the tool gives cryptic errors.

I have currently managed to solve this issue by changing

where CAST(users.login AS BINARY) regexp '[A-Z]{8}'

to

where CAST(users.login AS BINARY) regexp binary '[A-Z]{8}'

at file /lib/ghtorrent/migrations/019_add_fake_to_users.rb, line: 13

Relevant dependency versions of the system are:

External Dependencies

• Ruby - ruby 2.5.8p224 (2020-03-31 revision 67882) [x86_64-linux]
• MySql - Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

Ruby Gems

• mysql2 (0.5.3)
• ghtorrent (0.11.1)
• sequel (4.49.0)
• bundler (2.3.1, default: 1.17.3)