http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10855
Nicole C. Engard <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #222 from Nicole C. Engard <[email protected]> --- There is a problem here - if you query these new tables and some of the old tables you get an error : ERROR 1267 (HY000): Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' Here's the query - we should probably fix the collation on the new table and/or the old tables. select s.subscriptionid, b.title from serial s left join biblio b using (biblionumber) left join additional_field_values d on (d.record_id=s.subscriptionid) left join authorised_values v on (d.value=v.authorised_value) -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
