set foreign_key_checks = 0; alter table accountlines convert to character set utf8 collate utf8_unicode_ci; alter table accountoffsets convert to character set utf8 collate utf8_unicode_ci; alter table action_logs convert to character set utf8 collate utf8_unicode_ci; alter table alert convert to character set utf8 collate utf8_unicode_ci; alter table aqbasket convert to character set utf8 collate utf8_unicode_ci; alter table aqbasketgroups convert to character set utf8 collate utf8_unicode_ci; alter table aqbasketusers convert to character set utf8 collate utf8_unicode_ci; alter table aqbooksellers convert to character set utf8 collate utf8_unicode_ci; alter table aqbudgetborrowers convert to character set utf8 collate utf8_unicode_ci; alter table aqbudgetperiods convert to character set utf8 collate utf8_unicode_ci; alter table aqbudgets convert to character set utf8 collate utf8_unicode_ci; alter table aqbudgets_planning convert to character set utf8 collate utf8_unicode_ci; alter table aqcontract convert to character set utf8 collate utf8_unicode_ci; alter table aqinvoices convert to character set utf8 collate utf8_unicode_ci; alter table aqorders convert to character set utf8 collate utf8_unicode_ci; alter table aqorders_items convert to character set utf8 collate utf8_unicode_ci; alter table aqorders_transfers convert to character set utf8 collate utf8_unicode_ci; alter table auth_header convert to character set utf8 collate utf8_unicode_ci; alter table auth_subfield_structure convert to character set utf8 collate utf8_unicode_ci; alter table auth_tag_structure convert to character set utf8 collate utf8_unicode_ci; alter table auth_types convert to character set utf8 collate utf8_unicode_ci; alter table authorised_values convert to character set utf8 collate utf8_unicode_ci; alter table authorised_values_branches convert to character set utf8 collate utf8_unicode_ci; alter table biblio convert to character set utf8 collate utf8_unicode_ci; alter table biblio_framework convert to character set utf8 collate utf8_unicode_ci; alter table biblioimages convert to character set utf8 collate utf8_unicode_ci; alter table biblioitems convert to character set utf8 collate utf8_unicode_ci; alter table borrower_attribute_types convert to character set utf8 collate utf8_unicode_ci; alter table borrower_attribute_types_branches convert to character set utf8 collate utf8_unicode_ci; alter table borrower_attributes convert to character set utf8 collate utf8_unicode_ci; alter table borrower_debarments convert to character set utf8 collate utf8_unicode_ci; alter table borrower_files convert to character set utf8 collate utf8_unicode_ci; alter table borrower_message_preferences convert to character set utf8 collate utf8_unicode_ci; alter table borrower_message_transport_preferences convert to character set utf8 collate utf8_unicode_ci; alter table borrower_modifications convert to character set utf8 collate utf8_unicode_ci; alter table borrowers convert to character set utf8 collate utf8_unicode_ci; alter table branch_borrower_circ_rules convert to character set utf8 collate utf8_unicode_ci; alter table branch_item_rules convert to character set utf8 collate utf8_unicode_ci; alter table branch_transfer_limits convert to character set utf8 collate utf8_unicode_ci; alter table branchcategories convert to character set utf8 collate utf8_unicode_ci; alter table branches convert to character set utf8 collate utf8_unicode_ci; alter table branchrelations convert to character set utf8 collate utf8_unicode_ci; alter table branchtransfers convert to character set utf8 collate utf8_unicode_ci; alter table browser convert to character set utf8 collate utf8_unicode_ci; alter table categories convert to character set utf8 collate utf8_unicode_ci; alter table categories_branches convert to character set utf8 collate utf8_unicode_ci; alter table cities convert to character set utf8 collate utf8_unicode_ci; alter table class_sort_rules convert to character set utf8 collate utf8_unicode_ci; alter table class_sources convert to character set utf8 collate utf8_unicode_ci; alter table collections convert to character set utf8 collate utf8_unicode_ci; alter table collections_tracking convert to character set utf8 collate utf8_unicode_ci; alter table course_instructors convert to character set utf8 collate utf8_unicode_ci; alter table course_items convert to character set utf8 collate utf8_unicode_ci; alter table course_reserves convert to character set utf8 collate utf8_unicode_ci; alter table courses convert to character set utf8 collate utf8_unicode_ci; alter table creator_batches convert to character set utf8 collate utf8_unicode_ci; alter table creator_images convert to character set utf8 collate utf8_unicode_ci; alter table creator_layouts convert to character set utf8 collate utf8_unicode_ci; alter table creator_templates convert to character set utf8 collate utf8_unicode_ci; alter table currency convert to character set utf8 collate utf8_unicode_ci; alter table default_borrower_circ_rules convert to character set utf8 collate utf8_unicode_ci; alter table default_branch_circ_rules convert to character set utf8 collate utf8_unicode_ci; alter table default_branch_item_rules convert to character set utf8 collate utf8_unicode_ci; alter table default_circ_rules convert to character set utf8 collate utf8_unicode_ci; alter table deletedbiblio convert to character set utf8 collate utf8_unicode_ci; alter table deletedbiblioitems convert to character set utf8 collate utf8_unicode_ci; alter table deletedborrowers convert to character set utf8 collate utf8_unicode_ci; alter table deleteditems convert to character set utf8 collate utf8_unicode_ci; alter table ethnicity convert to character set utf8 collate utf8_unicode_ci; alter table export_format convert to character set utf8 collate utf8_unicode_ci; alter table fieldmapping convert to character set utf8 collate utf8_unicode_ci; alter table foo convert to character set utf8 collate utf8_unicode_ci; alter table hold_fill_targets convert to character set utf8 collate utf8_unicode_ci; alter table import_auths convert to character set utf8 collate utf8_unicode_ci; alter table import_batches convert to character set utf8 collate utf8_unicode_ci; alter table import_biblios convert to character set utf8 collate utf8_unicode_ci; alter table import_items convert to character set utf8 collate utf8_unicode_ci; alter table import_record_matches convert to character set utf8 collate utf8_unicode_ci; alter table import_records convert to character set utf8 collate utf8_unicode_ci; alter table issues convert to character set utf8 collate utf8_unicode_ci; alter table issuingrules convert to character set utf8 collate utf8_unicode_ci; alter table item_circulation_alert_preferences convert to character set utf8 collate utf8_unicode_ci; alter table items convert to character set utf8 collate utf8_unicode_ci; alter table itemtypes convert to character set utf8 collate utf8_unicode_ci; alter table language_descriptions convert to character set utf8 collate utf8_unicode_ci; alter table language_rfc4646_to_iso639 convert to character set utf8 collate utf8_unicode_ci; alter table language_script_bidi convert to character set utf8 collate utf8_unicode_ci; alter table language_script_mapping convert to character set utf8 collate utf8_unicode_ci; alter table language_subtag_registry convert to character set utf8 collate utf8_unicode_ci; alter table letter convert to character set utf8 collate utf8_unicode_ci; alter table linktracker convert to character set utf8 collate utf8_unicode_ci; alter table marc_matchers convert to character set utf8 collate utf8_unicode_ci; alter table marc_modification_template_actions convert to character set utf8 collate utf8_unicode_ci; alter table marc_modification_templates convert to character set utf8 collate utf8_unicode_ci; alter table marc_subfield_structure convert to character set utf8 collate utf8_unicode_ci; alter table marc_tag_structure convert to character set utf8 collate utf8_unicode_ci; alter table matchchecks convert to character set utf8 collate utf8_unicode_ci; alter table matcher_matchpoints convert to character set utf8 collate utf8_unicode_ci; alter table matchpoint_component_norms convert to character set utf8 collate utf8_unicode_ci; alter table matchpoint_components convert to character set utf8 collate utf8_unicode_ci; alter table matchpoints convert to character set utf8 collate utf8_unicode_ci; alter table message_attributes convert to character set utf8 collate utf8_unicode_ci; alter table message_queue convert to character set utf8 collate utf8_unicode_ci; alter table message_transport_types convert to character set utf8 collate utf8_unicode_ci; alter table message_transports convert to character set utf8 collate utf8_unicode_ci; alter table messages convert to character set utf8 collate utf8_unicode_ci; alter table need_merge_authorities convert to character set utf8 collate utf8_unicode_ci; alter table notifys convert to character set utf8 collate utf8_unicode_ci; alter table oai_sets convert to character set utf8 collate utf8_unicode_ci; alter table oai_sets_biblios convert to character set utf8 collate utf8_unicode_ci; alter table oai_sets_descriptions convert to character set utf8 collate utf8_unicode_ci; alter table oai_sets_mappings convert to character set utf8 collate utf8_unicode_ci; alter table old_issues convert to character set utf8 collate utf8_unicode_ci; alter table old_reserves convert to character set utf8 collate utf8_unicode_ci; alter table opac_news convert to character set utf8 collate utf8_unicode_ci; alter table overduerules convert to character set utf8 collate utf8_unicode_ci; alter table patron_list_patrons convert to character set utf8 collate utf8_unicode_ci; alter table patron_lists convert to character set utf8 collate utf8_unicode_ci; alter table patroncards convert to character set utf8 collate utf8_unicode_ci; alter table patronimage convert to character set utf8 collate utf8_unicode_ci; alter table pending_offline_operations convert to character set utf8 collate utf8_unicode_ci; alter table permissions convert to character set utf8 collate utf8_unicode_ci; alter table plugin_data convert to character set utf8 collate utf8_unicode_ci; alter table printers convert to character set utf8 collate utf8_unicode_ci; alter table printers_profile convert to character set utf8 collate utf8_unicode_ci; alter table quotes convert to character set utf8 collate utf8_unicode_ci; alter table ratings convert to character set utf8 collate utf8_unicode_ci; alter table repeatable_holidays convert to character set utf8 collate utf8_unicode_ci; alter table reports_dictionary convert to character set utf8 collate utf8_unicode_ci; alter table reserveconstraints convert to character set utf8 collate utf8_unicode_ci; alter table reserves convert to character set utf8 collate utf8_unicode_ci; alter table reviews convert to character set utf8 collate utf8_unicode_ci; alter table saved_reports convert to character set utf8 collate utf8_unicode_ci; alter table saved_sql convert to character set utf8 collate utf8_unicode_ci; alter table search_history convert to character set utf8 collate utf8_unicode_ci; alter table serial convert to character set utf8 collate utf8_unicode_ci; alter table serialitems convert to character set utf8 collate utf8_unicode_ci; alter table services_throttle convert to character set utf8 collate utf8_unicode_ci; alter table sessions convert to character set utf8 collate utf8_unicode_ci; alter table social_data convert to character set utf8 collate utf8_unicode_ci; alter table special_holidays convert to character set utf8 collate utf8_unicode_ci; alter table statistics convert to character set utf8 collate utf8_unicode_ci; alter table stopwords convert to character set utf8 collate utf8_unicode_ci; alter table subscription convert to character set utf8 collate utf8_unicode_ci; alter table subscription_frequencies convert to character set utf8 collate utf8_unicode_ci; alter table subscription_numberpatterns convert to character set utf8 collate utf8_unicode_ci; alter table subscriptionhistory convert to character set utf8 collate utf8_unicode_ci; alter table subscriptionroutinglist convert to character set utf8 collate utf8_unicode_ci; alter table suggestions convert to character set utf8 collate utf8_unicode_ci; alter table systempreferences convert to character set utf8 collate utf8_unicode_ci; alter table tags convert to character set utf8 collate utf8_unicode_ci; alter table tags_all convert to character set utf8 collate utf8_unicode_ci; alter table tags_approval convert to character set utf8 collate utf8_unicode_ci; alter table tags_index convert to character set utf8 collate utf8_unicode_ci; alter table tmp_accountlines convert to character set utf8 collate utf8_unicode_ci; alter table tmp_holdsqueue convert to character set utf8 collate utf8_unicode_ci; alter table transport_cost convert to character set utf8 collate utf8_unicode_ci; alter table user_permissions convert to character set utf8 collate utf8_unicode_ci; alter table userflags convert to character set utf8 collate utf8_unicode_ci; alter table virtualshelfcontents convert to character set utf8 collate utf8_unicode_ci; alter table virtualshelfshares convert to character set utf8 collate utf8_unicode_ci; alter table virtualshelves convert to character set utf8 collate utf8_unicode_ci; alter table z3950servers convert to character set utf8 collate utf8_unicode_ci; alter table zebraqueue convert to character set utf8 collate utf8_unicode_ci; set foreign_key_checks = 1;