[Koha-bugs] [Bug 13577] The correct COLLATE is not set to all DB tables

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Apr 22 11:51:11 CEST 2015


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13577

Dobrica Pavlinusic <dpavlin at rot13.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dpavlin at rot13.org

--- Comment #11 from Dobrica Pavlinusic <dpavlin at rot13.org> ---
We have a minor problem with databases created with 

When trying to access it with mysql client from command line, I get following
error in where:

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and
(utf8_general_ci,IMPLICIT) for operation '='

However, fix is simple:

mysql> alter database koha collate = 'utf8_unicode_ci' ;

I'm wondering if we should alter database collate also to avoid problems like
this.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list