[Koha-bugs] [Bug 18336] Use utf8mb4 instead of utf8 for MySQL tables, columns, and connections

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18336

--- Comment #1 from David Cook <dcook at prosentient.com.au> ---
Interestingly DBD::mysql actually recommends using mysql_enable_utf8mb4 over
mysql_enable_utf8 http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm. It
looks like we might be calling SET NAMES redundantly in Koha::Database as well,
but I don't think that matters too much.

You can use the following query to see if you have any incomplete MARCXML
records in Koha:

select biblionumber,metadata from biblio_metadata where
ExtractValue(metadata,'/record') is null;

Actually, that query is useful for finding any MARCXML record that will cause a
XML parser to fail.

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