cprevojs_cad2: ============== Table: access_keys: ------------------- * access_key_id: bigint(20) => not relevant * context: varchar(40) => must be converted * key_hash: varchar(40) => must be converted * user_id: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * expiry_date: datetime => not relevant UPDATE `access_keys` SET `context` = CONVERT(CAST(CONVERT(`context` USING latin1) AS binary) USING utf8), `key_hash` = CONVERT(CAST(CONVERT(`key_hash` USING latin1) AS binary) USING utf8) -- Table: announcement_settings: ----------------------------- * announcement_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `announcement_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: announcement_type_settings: ---------------------------------- * type_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `announcement_type_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: announcement_types: -------------------------- * type_id: bigint(20) => not relevant * assoc_type: smallint(6) => not relevant * assoc_id: bigint(20) => not relevant -- Table: announcements: --------------------- * announcement_id: bigint(20) => not relevant * assoc_type: smallint(6) => not relevant * assoc_id: bigint(20) => not relevant * type_id: bigint(20) => not relevant * date_expire: datetime => not relevant * date_posted: datetime => not relevant -- Table: article_event_log: ------------------------- * log_id: bigint(20) => not relevant * article_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * date_logged: datetime => not relevant * ip_address: varchar(15) => must be converted * log_level: varchar(1) => must be converted * event_type: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * message: text => must be converted UPDATE `article_event_log` SET `ip_address` = CONVERT(CAST(CONVERT(`ip_address` USING latin1) AS binary) USING utf8), `log_level` = CONVERT(CAST(CONVERT(`log_level` USING latin1) AS binary) USING utf8), `message` = CONVERT(CAST(CONVERT(`message` USING latin1) AS binary) USING utf8) -- Table: auth_sources: -------------------- * auth_id: bigint(20) => not relevant * title: varchar(60) => must be converted * plugin: varchar(32) => must be converted * auth_default: tinyint(4) => not relevant * settings: text => must be converted UPDATE `auth_sources` SET `title` = CONVERT(CAST(CONVERT(`title` USING latin1) AS binary) USING utf8), `plugin` = CONVERT(CAST(CONVERT(`plugin` USING latin1) AS binary) USING utf8), `settings` = CONVERT(CAST(CONVERT(`settings` USING latin1) AS binary) USING utf8) -- Table: author_settings: ----------------------- * author_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `author_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: authors: --------------- * author_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * seq: double => not relevant * email: varchar(90) => must be converted * user_group_id: bigint(20) => not relevant * include_in_browse: tinyint(4) => not relevant * publication_id: bigint(20) => not relevant UPDATE `authors` SET `email` = CONVERT(CAST(CONVERT(`email` USING latin1) AS binary) USING utf8) -- Table: books_for_review: ------------------------ * book_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * status: smallint(6) => not relevant * author_type: smallint(6) => not relevant * publisher: varchar(255) => must be converted * year: smallint(6) => not relevant * language: varchar(10) => must be converted * copy: tinyint(4) => not relevant * url: varchar(255) => must be converted * edition: tinyint(4) => not relevant * pages: smallint(6) => not relevant * isbn: varchar(30) => must be converted * date_created: datetime => not relevant * date_requested: datetime => not relevant * date_assigned: datetime => not relevant * date_mailed: datetime => not relevant * date_due: datetime => not relevant * date_submitted: datetime => not relevant * user_id: bigint(20) => not relevant * editor_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * notes: text => must be converted UPDATE `books_for_review` SET `publisher` = CONVERT(CAST(CONVERT(`publisher` USING latin1) AS binary) USING utf8), `language` = CONVERT(CAST(CONVERT(`language` USING latin1) AS binary) USING utf8), `url` = CONVERT(CAST(CONVERT(`url` USING latin1) AS binary) USING utf8), `isbn` = CONVERT(CAST(CONVERT(`isbn` USING latin1) AS binary) USING utf8), `notes` = CONVERT(CAST(CONVERT(`notes` USING latin1) AS binary) USING utf8) -- Table: books_for_review_authors: -------------------------------- * author_id: bigint(20) => not relevant * book_id: bigint(20) => not relevant * seq: double => not relevant * first_name: varchar(40) => must be converted * middle_name: varchar(40) => must be converted * last_name: varchar(90) => must be converted UPDATE `books_for_review_authors` SET `first_name` = CONVERT(CAST(CONVERT(`first_name` USING latin1) AS binary) USING utf8), `middle_name` = CONVERT(CAST(CONVERT(`middle_name` USING latin1) AS binary) USING utf8), `last_name` = CONVERT(CAST(CONVERT(`last_name` USING latin1) AS binary) USING utf8) -- Table: books_for_review_settings: --------------------------------- * book_id: bigint(20) => not relevant * locale: varchar(5) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `books_for_review_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: captchas: ---------------- * captcha_id: bigint(20) => not relevant * session_id: varchar(128) => must be converted * value: varchar(20) => must be converted * date_created: datetime => not relevant UPDATE `captchas` SET `session_id` = CONVERT(CAST(CONVERT(`session_id` USING latin1) AS binary) USING utf8), `value` = CONVERT(CAST(CONVERT(`value` USING latin1) AS binary) USING utf8) -- Table: categories: ------------------ * category_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * parent_id: bigint(20) => not relevant * seq: bigint(20) => not relevant * path: varchar(255) => must be converted * image: text => must be converted UPDATE `categories` SET `path` = CONVERT(CAST(CONVERT(`path` USING latin1) AS binary) USING utf8), `image` = CONVERT(CAST(CONVERT(`image` USING latin1) AS binary) USING utf8) -- Table: category_settings: ------------------------- * category_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `category_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: citation_settings: ------------------------- * citation_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `citation_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: citations: ----------------- * citation_id: bigint(20) => not relevant * publication_id: bigint(20) => not relevant * raw_citation: text => must be converted * seq: bigint(20) => not relevant UPDATE `citations` SET `raw_citation` = CONVERT(CAST(CONVERT(`raw_citation` USING latin1) AS binary) USING utf8) -- Table: comments: ---------------- * comment_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * parent_comment_id: bigint(20) => not relevant * num_children: int(11) => not relevant * user_id: bigint(20) => not relevant * poster_ip: varchar(15) => must be converted * poster_name: varchar(90) => must be converted * poster_email: varchar(90) => must be converted * title: varchar(255) => must be converted * body: text => must be converted * date_posted: datetime => not relevant * date_modified: datetime => not relevant UPDATE `comments` SET `poster_ip` = CONVERT(CAST(CONVERT(`poster_ip` USING latin1) AS binary) USING utf8), `poster_name` = CONVERT(CAST(CONVERT(`poster_name` USING latin1) AS binary) USING utf8), `poster_email` = CONVERT(CAST(CONVERT(`poster_email` USING latin1) AS binary) USING utf8), `title` = CONVERT(CAST(CONVERT(`title` USING latin1) AS binary) USING utf8), `body` = CONVERT(CAST(CONVERT(`body` USING latin1) AS binary) USING utf8) -- Table: completed_payments: -------------------------- * completed_payment_id: bigint(20) => not relevant * timestamp: datetime => not relevant * payment_type: bigint(20) => not relevant * context_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * amount: double => not relevant * currency_code_alpha: varchar(3) => must be converted * payment_method_plugin_name: varchar(80) => must be converted UPDATE `completed_payments` SET `currency_code_alpha` = CONVERT(CAST(CONVERT(`currency_code_alpha` USING latin1) AS binary) USING utf8), `payment_method_plugin_name` = CONVERT(CAST(CONVERT(`payment_method_plugin_name` USING latin1) AS binary) USING utf8) -- Table: controlled_vocab_entries: -------------------------------- * controlled_vocab_entry_id: bigint(20) => not relevant * controlled_vocab_id: bigint(20) => not relevant * seq: double => not relevant -- Table: controlled_vocab_entry_settings: --------------------------------------- * controlled_vocab_entry_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `controlled_vocab_entry_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: controlled_vocabs: ------------------------- * controlled_vocab_id: bigint(20) => not relevant * symbolic: varchar(64) => must be converted * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant UPDATE `controlled_vocabs` SET `symbolic` = CONVERT(CAST(CONVERT(`symbolic` USING latin1) AS binary) USING utf8) -- Table: custom_issue_orders: --------------------------- * issue_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * seq: double => not relevant -- Table: custom_section_orders: ----------------------------- * issue_id: bigint(20) => not relevant * section_id: bigint(20) => not relevant * seq: double => not relevant -- Table: data_object_tombstone_oai_set_objects: --------------------------------------------- * object_id: bigint(20) => not relevant * tombstone_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant -- Table: data_object_tombstone_settings: -------------------------------------- * tombstone_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `data_object_tombstone_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: data_object_tombstones: ------------------------------ * tombstone_id: bigint(20) => not relevant * data_object_id: bigint(20) => not relevant * date_deleted: datetime => not relevant * set_spec: varchar(255) => must be converted * set_name: varchar(255) => must be converted * oai_identifier: varchar(255) => must be converted UPDATE `data_object_tombstones` SET `set_spec` = CONVERT(CAST(CONVERT(`set_spec` USING latin1) AS binary) USING utf8), `set_name` = CONVERT(CAST(CONVERT(`set_name` USING latin1) AS binary) USING utf8), `oai_identifier` = CONVERT(CAST(CONVERT(`oai_identifier` USING latin1) AS binary) USING utf8) -- Table: dataverse_files: ----------------------- * dvfile_id: bigint(20) => not relevant * supp_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * study_id: bigint(20) => not relevant * content_source_uri: varchar(255) => must be converted UPDATE `dataverse_files` SET `content_source_uri` = CONVERT(CAST(CONVERT(`content_source_uri` USING latin1) AS binary) USING utf8) -- Table: dataverse_studies: ------------------------- * study_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * edit_uri: varchar(255) => must be converted * edit_media_uri: varchar(255) => must be converted * statement_uri: varchar(255) => must be converted * persistent_uri: varchar(255) => must be converted * data_citation: text => must be converted UPDATE `dataverse_studies` SET `edit_uri` = CONVERT(CAST(CONVERT(`edit_uri` USING latin1) AS binary) USING utf8), `edit_media_uri` = CONVERT(CAST(CONVERT(`edit_media_uri` USING latin1) AS binary) USING utf8), `statement_uri` = CONVERT(CAST(CONVERT(`statement_uri` USING latin1) AS binary) USING utf8), `persistent_uri` = CONVERT(CAST(CONVERT(`persistent_uri` USING latin1) AS binary) USING utf8), `data_citation` = CONVERT(CAST(CONVERT(`data_citation` USING latin1) AS binary) USING utf8) -- Table: edit_assignments: ------------------------ * edit_id: bigint(20) => not relevant * article_id: bigint(20) => not relevant * editor_id: bigint(20) => not relevant * can_edit: tinyint(4) => not relevant * can_review: tinyint(4) => not relevant * date_assigned: datetime => not relevant * date_notified: datetime => not relevant * date_underway: datetime => not relevant -- Table: edit_decisions: ---------------------- * edit_decision_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * round: tinyint(4) => not relevant * editor_id: bigint(20) => not relevant * decision: tinyint(4) => not relevant * date_decided: datetime => not relevant * review_round_id: bigint(20) => not relevant * stage_id: bigint(20) => not relevant -- Table: email_log: ----------------- * log_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * sender_id: bigint(20) => not relevant * date_sent: datetime => not relevant * event_type: bigint(20) => not relevant * from_address: varchar(255) => must be converted * recipients: text => must be converted * cc_recipients: text => must be converted * bcc_recipients: text => must be converted * subject: varchar(255) => must be converted * body: text => must be converted UPDATE `email_log` SET `from_address` = CONVERT(CAST(CONVERT(`from_address` USING latin1) AS binary) USING utf8), `recipients` = CONVERT(CAST(CONVERT(`recipients` USING latin1) AS binary) USING utf8), `cc_recipients` = CONVERT(CAST(CONVERT(`cc_recipients` USING latin1) AS binary) USING utf8), `bcc_recipients` = CONVERT(CAST(CONVERT(`bcc_recipients` USING latin1) AS binary) USING utf8), `subject` = CONVERT(CAST(CONVERT(`subject` USING latin1) AS binary) USING utf8), `body` = CONVERT(CAST(CONVERT(`body` USING latin1) AS binary) USING utf8) -- Table: email_log_users: ----------------------- * email_log_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant -- Table: email_templates: ----------------------- * email_id: bigint(20) => not relevant * email_key: varchar(64) => must be converted * enabled: tinyint(4) => not relevant * context_id: bigint(20) => not relevant UPDATE `email_templates` SET `email_key` = CONVERT(CAST(CONVERT(`email_key` USING latin1) AS binary) USING utf8) -- Table: email_templates_default: ------------------------------- * email_id: bigint(20) => not relevant * email_key: varchar(64) => must be converted * can_disable: tinyint(4) => not relevant * can_edit: tinyint(4) => not relevant * from_role_id: bigint(20) => not relevant * to_role_id: bigint(20) => not relevant UPDATE `email_templates_default` SET `email_key` = CONVERT(CAST(CONVERT(`email_key` USING latin1) AS binary) USING utf8) -- Table: email_templates_default_data: ------------------------------------ * email_key: varchar(64) => must be converted * locale: varchar(14) => must be converted * subject: varchar(120) => must be converted * body: text => must be converted * description: text => must be converted UPDATE `email_templates_default_data` SET `email_key` = CONVERT(CAST(CONVERT(`email_key` USING latin1) AS binary) USING utf8), `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `subject` = CONVERT(CAST(CONVERT(`subject` USING latin1) AS binary) USING utf8), `body` = CONVERT(CAST(CONVERT(`body` USING latin1) AS binary) USING utf8), `description` = CONVERT(CAST(CONVERT(`description` USING latin1) AS binary) USING utf8) -- Table: email_templates_settings: -------------------------------- * email_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted UPDATE `email_templates_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8) -- Table: event_log: ----------------- * log_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * date_logged: datetime => not relevant * event_type: bigint(20) => not relevant * message: text => must be converted * is_translated: tinyint(4) => not relevant UPDATE `event_log` SET `message` = CONVERT(CAST(CONVERT(`message` USING latin1) AS binary) USING utf8) -- Table: event_log_settings: -------------------------- * log_id: bigint(20) => not relevant * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `event_log_settings` SET `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: external_feed_settings: ------------------------------ * feed_id: bigint(20) => not relevant * locale: varchar(5) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `external_feed_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: external_feeds: ---------------------- * feed_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * url: varchar(255) => must be converted * seq: double => not relevant * display_homepage: tinyint(4) => not relevant * display_block: smallint(6) => not relevant * limit_items: tinyint(4) => not relevant * recent_items: smallint(6) => not relevant UPDATE `external_feeds` SET `url` = CONVERT(CAST(CONVERT(`url` USING latin1) AS binary) USING utf8) -- Table: filter_groups: --------------------- * filter_group_id: bigint(20) => not relevant * symbolic: varchar(255) => must be converted * display_name: varchar(255) => must be converted * description: varchar(255) => must be converted * input_type: varchar(255) => must be converted * output_type: varchar(255) => must be converted UPDATE `filter_groups` SET `symbolic` = CONVERT(CAST(CONVERT(`symbolic` USING latin1) AS binary) USING utf8), `display_name` = CONVERT(CAST(CONVERT(`display_name` USING latin1) AS binary) USING utf8), `description` = CONVERT(CAST(CONVERT(`description` USING latin1) AS binary) USING utf8), `input_type` = CONVERT(CAST(CONVERT(`input_type` USING latin1) AS binary) USING utf8), `output_type` = CONVERT(CAST(CONVERT(`output_type` USING latin1) AS binary) USING utf8) -- Table: filter_settings: ----------------------- * filter_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `filter_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: filters: --------------- * filter_id: bigint(20) => not relevant * filter_group_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * display_name: varchar(255) => must be converted * class_name: varchar(255) => must be converted * is_template: tinyint(4) => not relevant * parent_filter_id: bigint(20) => not relevant * seq: bigint(20) => not relevant UPDATE `filters` SET `display_name` = CONVERT(CAST(CONVERT(`display_name` USING latin1) AS binary) USING utf8), `class_name` = CONVERT(CAST(CONVERT(`class_name` USING latin1) AS binary) USING utf8) -- Table: genre_settings: ---------------------- * genre_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `genre_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: genres: -------------- * genre_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * seq: bigint(20) => not relevant * enabled: tinyint(4) => not relevant * category: bigint(20) => not relevant * dependent: tinyint(4) => not relevant * supplementary: tinyint(4) => not relevant * entry_key: varchar(30) => must be converted UPDATE `genres` SET `entry_key` = CONVERT(CAST(CONVERT(`entry_key` USING latin1) AS binary) USING utf8) -- Table: group_memberships: ------------------------- * user_id: bigint(20) => not relevant * group_id: bigint(20) => not relevant * about_displayed: tinyint(4) => not relevant * seq: double => not relevant -- Table: group_settings: ---------------------- * group_id: bigint(20) => not relevant * locale: varchar(5) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `group_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: groups: -------------- * group_id: bigint(20) => not relevant * assoc_type: smallint(6) => not relevant * publish_email: smallint(6) => not relevant * assoc_id: bigint(20) => not relevant * context: bigint(20) => not relevant * about_displayed: tinyint(4) => not relevant * seq: double => not relevant -- Table: institutional_subscription_ip: ------------------------------------- * institutional_subscription_ip_id: bigint(20) => not relevant * subscription_id: bigint(20) => not relevant * ip_string: varchar(40) => must be converted * ip_start: bigint(20) => not relevant * ip_end: bigint(20) => not relevant UPDATE `institutional_subscription_ip` SET `ip_string` = CONVERT(CAST(CONVERT(`ip_string` USING latin1) AS binary) USING utf8) -- Table: institutional_subscriptions: ----------------------------------- * institutional_subscription_id: bigint(20) => not relevant * subscription_id: bigint(20) => not relevant * institution_name: varchar(255) => must be converted * mailing_address: varchar(255) => must be converted * domain: varchar(255) => must be converted UPDATE `institutional_subscriptions` SET `institution_name` = CONVERT(CAST(CONVERT(`institution_name` USING latin1) AS binary) USING utf8), `mailing_address` = CONVERT(CAST(CONVERT(`mailing_address` USING latin1) AS binary) USING utf8), `domain` = CONVERT(CAST(CONVERT(`domain` USING latin1) AS binary) USING utf8) -- Table: issue_files: ------------------- * file_id: bigint(20) => not relevant * issue_id: bigint(20) => not relevant * file_name: varchar(90) => must be converted * file_type: varchar(255) => must be converted * file_size: bigint(20) => not relevant * content_type: bigint(20) => not relevant * original_file_name: varchar(127) => must be converted * date_uploaded: datetime => not relevant * date_modified: datetime => not relevant UPDATE `issue_files` SET `file_name` = CONVERT(CAST(CONVERT(`file_name` USING latin1) AS binary) USING utf8), `file_type` = CONVERT(CAST(CONVERT(`file_type` USING latin1) AS binary) USING utf8), `original_file_name` = CONVERT(CAST(CONVERT(`original_file_name` USING latin1) AS binary) USING utf8) -- Table: issue_galley_settings: ----------------------------- * galley_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `issue_galley_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: issue_galleys: --------------------- * galley_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * issue_id: bigint(20) => not relevant * file_id: bigint(20) => not relevant * label: varchar(32) => must be converted * seq: double => not relevant * url_path: varchar(64) => must be converted UPDATE `issue_galleys` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `label` = CONVERT(CAST(CONVERT(`label` USING latin1) AS binary) USING utf8), `url_path` = CONVERT(CAST(CONVERT(`url_path` USING latin1) AS binary) USING utf8) -- Table: issue_settings: ---------------------- * issue_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `issue_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: issues: -------------- * issue_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * volume: smallint(6) => not relevant * number: varchar(40) => must be converted * year: smallint(6) => not relevant * published: tinyint(4) => not relevant * current: tinyint(4) => not relevant * date_published: datetime => not relevant * date_notified: datetime => not relevant * access_status: tinyint(4) => not relevant * open_access_date: datetime => not relevant * show_volume: tinyint(4) => not relevant * show_number: tinyint(4) => not relevant * show_year: tinyint(4) => not relevant * show_title: tinyint(4) => not relevant * style_file_name: varchar(90) => must be converted * original_style_file_name: varchar(255) => must be converted * last_modified: datetime => not relevant * url_path: varchar(64) => must be converted UPDATE `issues` SET `number` = CONVERT(CAST(CONVERT(`number` USING latin1) AS binary) USING utf8), `style_file_name` = CONVERT(CAST(CONVERT(`style_file_name` USING latin1) AS binary) USING utf8), `original_style_file_name` = CONVERT(CAST(CONVERT(`original_style_file_name` USING latin1) AS binary) USING utf8), `url_path` = CONVERT(CAST(CONVERT(`url_path` USING latin1) AS binary) USING utf8) -- Table: item_views: ------------------ * assoc_type: bigint(20) => not relevant * assoc_id: varchar(32) => must be converted * user_id: bigint(20) => not relevant * date_last_viewed: datetime => not relevant UPDATE `item_views` SET `assoc_id` = CONVERT(CAST(CONVERT(`assoc_id` USING latin1) AS binary) USING utf8) -- Table: journal_settings: ------------------------ * journal_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `journal_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: journals: ---------------- * journal_id: bigint(20) => not relevant * path: varchar(32) => must be converted * seq: double => not relevant * primary_locale: varchar(14) => must be converted * enabled: tinyint(4) => not relevant UPDATE `journals` SET `path` = CONVERT(CAST(CONVERT(`path` USING latin1) AS binary) USING utf8), `primary_locale` = CONVERT(CAST(CONVERT(`primary_locale` USING latin1) AS binary) USING utf8) -- Table: library_file_settings: ----------------------------- * file_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `library_file_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: library_files: --------------------- * file_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * file_name: varchar(255) => must be converted * original_file_name: varchar(255) => must be converted * file_type: varchar(255) => must be converted * file_size: bigint(20) => not relevant * type: tinyint(4) => not relevant * date_uploaded: datetime => not relevant * date_modified: datetime => not relevant * submission_id: bigint(20) => not relevant * public_access: tinyint(4) => not relevant UPDATE `library_files` SET `file_name` = CONVERT(CAST(CONVERT(`file_name` USING latin1) AS binary) USING utf8), `original_file_name` = CONVERT(CAST(CONVERT(`original_file_name` USING latin1) AS binary) USING utf8), `file_type` = CONVERT(CAST(CONVERT(`file_type` USING latin1) AS binary) USING utf8) -- Table: metadata_description_settings: ------------------------------------- * metadata_description_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `metadata_description_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: metadata_descriptions: ----------------------------- * metadata_description_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * schema_namespace: varchar(255) => must be converted * schema_name: varchar(255) => must be converted * display_name: varchar(255) => must be converted * seq: bigint(20) => not relevant UPDATE `metadata_descriptions` SET `schema_namespace` = CONVERT(CAST(CONVERT(`schema_namespace` USING latin1) AS binary) USING utf8), `schema_name` = CONVERT(CAST(CONVERT(`schema_name` USING latin1) AS binary) USING utf8), `display_name` = CONVERT(CAST(CONVERT(`display_name` USING latin1) AS binary) USING utf8) -- Table: metrics: --------------- * load_id: varchar(255) => must be converted * assoc_type: bigint(20) => not relevant * context_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * day: varchar(8) => must be converted * month: varchar(6) => must be converted * file_type: tinyint(4) => not relevant * country_id: varchar(2) => must be converted * region: varchar(2) => must be converted * city: varchar(255) => must be converted * metric_type: varchar(255) => must be converted * metric: int(11) => not relevant * pkp_section_id: bigint(20) => not relevant * assoc_object_type: bigint(20) => not relevant * assoc_object_id: bigint(20) => not relevant * representation_id: bigint(20) => not relevant UPDATE `metrics` SET `load_id` = CONVERT(CAST(CONVERT(`load_id` USING latin1) AS binary) USING utf8), `day` = CONVERT(CAST(CONVERT(`day` USING latin1) AS binary) USING utf8), `month` = CONVERT(CAST(CONVERT(`month` USING latin1) AS binary) USING utf8), `country_id` = CONVERT(CAST(CONVERT(`country_id` USING latin1) AS binary) USING utf8), `region` = CONVERT(CAST(CONVERT(`region` USING latin1) AS binary) USING utf8), `city` = CONVERT(CAST(CONVERT(`city` USING latin1) AS binary) USING utf8), `metric_type` = CONVERT(CAST(CONVERT(`metric_type` USING latin1) AS binary) USING utf8) -- Table: mutex: ------------- * i: tinyint(4) => not relevant -- Table: navigation_menu_item_assignment_settings: ------------------------------------------------ * navigation_menu_item_assignment_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `navigation_menu_item_assignment_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: navigation_menu_item_assignments: ---------------------------------------- * navigation_menu_item_assignment_id: bigint(20) => not relevant * navigation_menu_id: bigint(20) => not relevant * navigation_menu_item_id: bigint(20) => not relevant * parent_id: bigint(20) => not relevant * seq: bigint(20) => not relevant -- Table: navigation_menu_item_settings: ------------------------------------- * navigation_menu_item_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: longtext => must be converted * setting_type: varchar(6) => must be converted UPDATE `navigation_menu_item_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: navigation_menu_items: ----------------------------- * navigation_menu_item_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * url: varchar(255) => must be converted * path: varchar(255) => must be converted * type: varchar(255) => must be converted UPDATE `navigation_menu_items` SET `url` = CONVERT(CAST(CONVERT(`url` USING latin1) AS binary) USING utf8), `path` = CONVERT(CAST(CONVERT(`path` USING latin1) AS binary) USING utf8), `type` = CONVERT(CAST(CONVERT(`type` USING latin1) AS binary) USING utf8) -- Table: navigation_menus: ------------------------ * navigation_menu_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * area_name: varchar(255) => must be converted * title: varchar(255) => must be converted UPDATE `navigation_menus` SET `area_name` = CONVERT(CAST(CONVERT(`area_name` USING latin1) AS binary) USING utf8), `title` = CONVERT(CAST(CONVERT(`title` USING latin1) AS binary) USING utf8) -- Table: notes: ------------- * note_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * date_created: datetime => not relevant * date_modified: datetime => not relevant * title: varchar(255) => must be converted * contents: text => must be converted UPDATE `notes` SET `title` = CONVERT(CAST(CONVERT(`title` USING latin1) AS binary) USING utf8), `contents` = CONVERT(CAST(CONVERT(`contents` USING latin1) AS binary) USING utf8) -- Table: notification_mail_list: ------------------------------ * notification_mail_list_id: bigint(20) => not relevant * email: varchar(90) => must be converted * confirmed: tinyint(4) => not relevant * token: varchar(40) => must be converted * context: bigint(20) => not relevant UPDATE `notification_mail_list` SET `email` = CONVERT(CAST(CONVERT(`email` USING latin1) AS binary) USING utf8), `token` = CONVERT(CAST(CONVERT(`token` USING latin1) AS binary) USING utf8) -- Table: notification_settings: ----------------------------- * notification_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(64) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `notification_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: notification_subscription_settings: ------------------------------------------ * setting_id: bigint(20) => not relevant * setting_name: varchar(64) => must be converted * setting_value: text => must be converted * user_id: bigint(20) => not relevant * context: bigint(20) => not relevant * setting_type: varchar(6) => must be converted UPDATE `notification_subscription_settings` SET `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: notifications: --------------------- * notification_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * level: bigint(20) => not relevant * type: bigint(20) => not relevant * date_created: datetime => not relevant * date_read: datetime => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant -- Table: oai_resumption_tokens: ----------------------------- * token: varchar(32) => must be converted * expire: bigint(20) => not relevant * record_offset: int(11) => not relevant * params: text => must be converted UPDATE `oai_resumption_tokens` SET `token` = CONVERT(CAST(CONVERT(`token` USING latin1) AS binary) USING utf8), `params` = CONVERT(CAST(CONVERT(`params` USING latin1) AS binary) USING utf8) -- Table: object_for_review_assignments: ------------------------------------- * assignment_id: bigint(20) => not relevant * object_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * status: smallint(6) => not relevant * date_requested: datetime => not relevant * date_assigned: datetime => not relevant * date_mailed: datetime => not relevant * date_due: datetime => not relevant * date_reminded_before: datetime => not relevant * date_reminded_after: datetime => not relevant * notes: text => must be converted UPDATE `object_for_review_assignments` SET `notes` = CONVERT(CAST(CONVERT(`notes` USING latin1) AS binary) USING utf8) -- Table: object_for_review_persons: --------------------------------- * person_id: bigint(20) => not relevant * object_id: bigint(20) => not relevant * seq: double => not relevant * role: varchar(255) => must be converted * first_name: varchar(40) => must be converted * middle_name: varchar(40) => must be converted * last_name: varchar(90) => must be converted UPDATE `object_for_review_persons` SET `role` = CONVERT(CAST(CONVERT(`role` USING latin1) AS binary) USING utf8), `first_name` = CONVERT(CAST(CONVERT(`first_name` USING latin1) AS binary) USING utf8), `middle_name` = CONVERT(CAST(CONVERT(`middle_name` USING latin1) AS binary) USING utf8), `last_name` = CONVERT(CAST(CONVERT(`last_name` USING latin1) AS binary) USING utf8) -- Table: object_for_review_settings: ---------------------------------- * object_id: bigint(20) => not relevant * review_object_metadata_id: bigint(20) => not relevant * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `object_for_review_settings` SET `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: objects_for_review: -------------------------- * object_id: bigint(20) => not relevant * review_object_type_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * available: tinyint(4) => not relevant * date_created: datetime => not relevant * editor_id: bigint(20) => not relevant * notes: text => must be converted UPDATE `objects_for_review` SET `notes` = CONVERT(CAST(CONVERT(`notes` USING latin1) AS binary) USING utf8) -- Table: paypal_transactions: --------------------------- * txn_id: varchar(17) => must be converted * txn_type: varchar(20) => must be converted * payer_email: varchar(127) => must be converted * receiver_email: varchar(127) => must be converted * item_number: varchar(127) => must be converted * payment_date: varchar(127) => must be converted * payer_id: varchar(13) => must be converted * receiver_id: varchar(13) => must be converted UPDATE `paypal_transactions` SET `txn_id` = CONVERT(CAST(CONVERT(`txn_id` USING latin1) AS binary) USING utf8), `txn_type` = CONVERT(CAST(CONVERT(`txn_type` USING latin1) AS binary) USING utf8), `payer_email` = CONVERT(CAST(CONVERT(`payer_email` USING latin1) AS binary) USING utf8), `receiver_email` = CONVERT(CAST(CONVERT(`receiver_email` USING latin1) AS binary) USING utf8), `item_number` = CONVERT(CAST(CONVERT(`item_number` USING latin1) AS binary) USING utf8), `payment_date` = CONVERT(CAST(CONVERT(`payment_date` USING latin1) AS binary) USING utf8), `payer_id` = CONVERT(CAST(CONVERT(`payer_id` USING latin1) AS binary) USING utf8), `receiver_id` = CONVERT(CAST(CONVERT(`receiver_id` USING latin1) AS binary) USING utf8) -- Table: pln_deposit_objects: --------------------------- * deposit_object_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * object_id: bigint(20) => not relevant * object_type: varchar(36) => must be converted * deposit_id: bigint(20) => not relevant * date_created: datetime => not relevant * date_modified: datetime => not relevant UPDATE `pln_deposit_objects` SET `object_type` = CONVERT(CAST(CONVERT(`object_type` USING latin1) AS binary) USING utf8) -- Table: pln_deposits: -------------------- * deposit_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * uuid: varchar(36) => must be converted * status: bigint(20) => not relevant * date_status: datetime => not relevant * date_created: datetime => not relevant * date_modified: datetime => not relevant UPDATE `pln_deposits` SET `uuid` = CONVERT(CAST(CONVERT(`uuid` USING latin1) AS binary) USING utf8) -- Table: plugin_settings: ----------------------- * plugin_name: varchar(80) => must be converted * context_id: bigint(20) => not relevant * setting_name: varchar(80) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `plugin_settings` SET `plugin_name` = CONVERT(CAST(CONVERT(`plugin_name` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: processes: ----------------- * process_id: varchar(23) => must be converted * process_type: tinyint(4) => not relevant * time_started: bigint(20) => not relevant * obliterated: tinyint(4) => not relevant * additional_data: text => must be converted UPDATE `processes` SET `process_id` = CONVERT(CAST(CONVERT(`process_id` USING latin1) AS binary) USING utf8), `additional_data` = CONVERT(CAST(CONVERT(`additional_data` USING latin1) AS binary) USING utf8) -- Table: publication_categories: ------------------------------ * publication_id: bigint(20) => not relevant * category_id: bigint(20) => not relevant -- Table: publication_galley_settings: ----------------------------------- * galley_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted UPDATE `publication_galley_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8) -- Table: publication_galleys: --------------------------- * galley_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * publication_id: bigint(20) => not relevant * label: varchar(255) => must be converted * file_id: bigint(20) => not relevant * seq: double => not relevant * remote_url: varchar(2047) => must be converted * is_approved: tinyint(4) => not relevant * url_path: varchar(64) => must be converted UPDATE `publication_galleys` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `label` = CONVERT(CAST(CONVERT(`label` USING latin1) AS binary) USING utf8), `remote_url` = CONVERT(CAST(CONVERT(`remote_url` USING latin1) AS binary) USING utf8), `url_path` = CONVERT(CAST(CONVERT(`url_path` USING latin1) AS binary) USING utf8) -- Table: publication_settings: ---------------------------- * publication_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted UPDATE `publication_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8) -- Table: publications: -------------------- * publication_id: bigint(20) => not relevant * access_status: bigint(20) => not relevant * date_published: date => not relevant * last_modified: datetime => not relevant * locale: varchar(14) => must be converted * primary_contact_id: bigint(20) => not relevant * section_id: bigint(20) => not relevant * seq: double => not relevant * submission_id: bigint(20) => not relevant * status: tinyint(4) => not relevant * url_path: varchar(64) => must be converted * version: bigint(20) => not relevant UPDATE `publications` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `url_path` = CONVERT(CAST(CONVERT(`url_path` USING latin1) AS binary) USING utf8) -- Table: queries: --------------- * query_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * stage_id: tinyint(4) => not relevant * seq: double => not relevant * date_posted: datetime => not relevant * date_modified: datetime => not relevant * closed: smallint(6) => not relevant -- Table: query_participants: -------------------------- * query_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant -- Table: queued_payments: ----------------------- * queued_payment_id: bigint(20) => not relevant * date_created: datetime => not relevant * date_modified: datetime => not relevant * expiry_date: date => not relevant * payment_data: text => must be converted UPDATE `queued_payments` SET `payment_data` = CONVERT(CAST(CONVERT(`payment_data` USING latin1) AS binary) USING utf8) -- Table: referral_settings: ------------------------- * referral_id: bigint(20) => not relevant * locale: varchar(5) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `referral_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: referrals: ----------------- * referral_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * status: smallint(6) => not relevant * url: varchar(255) => must be converted * date_added: datetime => not relevant * link_count: bigint(20) => not relevant UPDATE `referrals` SET `url` = CONVERT(CAST(CONVERT(`url` USING latin1) AS binary) USING utf8) -- Table: review_assignments: -------------------------- * review_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * reviewer_id: bigint(20) => not relevant * competing_interests: text => must be converted * recommendation: tinyint(4) => not relevant * date_assigned: datetime => not relevant * date_notified: datetime => not relevant * date_confirmed: datetime => not relevant * date_completed: datetime => not relevant * date_acknowledged: datetime => not relevant * date_due: datetime => not relevant * date_response_due: datetime => not relevant * last_modified: datetime => not relevant * reminder_was_automatic: tinyint(4) => not relevant * declined: tinyint(4) => not relevant * reviewer_file_id: bigint(20) => not relevant * date_rated: datetime => not relevant * date_reminded: datetime => not relevant * quality: tinyint(4) => not relevant * review_round_id: bigint(20) => not relevant * stage_id: tinyint(4) => not relevant * review_method: tinyint(4) => not relevant * round: tinyint(4) => not relevant * step: tinyint(4) => not relevant * review_form_id: bigint(20) => not relevant * unconsidered: tinyint(4) => not relevant * cancelled: tinyint(4) => not relevant UPDATE `review_assignments` SET `competing_interests` = CONVERT(CAST(CONVERT(`competing_interests` USING latin1) AS binary) USING utf8) -- Table: review_files: -------------------- * review_id: bigint(20) => not relevant * file_id: bigint(20) => not relevant -- Table: review_form_element_settings: ------------------------------------ * review_form_element_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `review_form_element_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: review_form_elements: ---------------------------- * review_form_element_id: bigint(20) => not relevant * review_form_id: bigint(20) => not relevant * seq: double => not relevant * element_type: bigint(20) => not relevant * required: tinyint(4) => not relevant * included: tinyint(4) => not relevant -- Table: review_form_responses: ----------------------------- * review_form_element_id: bigint(20) => not relevant * review_id: bigint(20) => not relevant * response_type: varchar(6) => must be converted * response_value: text => must be converted UPDATE `review_form_responses` SET `response_type` = CONVERT(CAST(CONVERT(`response_type` USING latin1) AS binary) USING utf8), `response_value` = CONVERT(CAST(CONVERT(`response_value` USING latin1) AS binary) USING utf8) -- Table: review_form_settings: ---------------------------- * review_form_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `review_form_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: review_forms: -------------------- * review_form_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * seq: double => not relevant * is_active: tinyint(4) => not relevant -- Table: review_object_metadata: ------------------------------ * metadata_id: bigint(20) => not relevant * review_object_type_id: bigint(20) => not relevant * seq: double => not relevant * metadata_type: bigint(20) => not relevant * required: tinyint(4) => not relevant * display: tinyint(4) => not relevant * metadata_key: varchar(64) => must be converted UPDATE `review_object_metadata` SET `metadata_key` = CONVERT(CAST(CONVERT(`metadata_key` USING latin1) AS binary) USING utf8) -- Table: review_object_metadata_settings: --------------------------------------- * metadata_id: bigint(20) => not relevant * locale: varchar(5) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `review_object_metadata_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: review_object_type_settings: ----------------------------------- * type_id: bigint(20) => not relevant * locale: varchar(5) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `review_object_type_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: review_object_types: --------------------------- * type_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * is_active: tinyint(4) => not relevant * type_key: varchar(64) => must be converted UPDATE `review_object_types` SET `type_key` = CONVERT(CAST(CONVERT(`type_key` USING latin1) AS binary) USING utf8) -- Table: review_round_files: -------------------------- * submission_id: bigint(20) => not relevant * review_round_id: bigint(20) => not relevant * stage_id: tinyint(4) => not relevant * file_id: bigint(20) => not relevant * revision: bigint(20) => not relevant -- Table: review_rounds: --------------------- * review_round_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * stage_id: bigint(20) => not relevant * round: tinyint(4) => not relevant * review_revision: bigint(20) => not relevant * status: bigint(20) => not relevant -- Table: roles: ------------- * journal_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * role_id: bigint(20) => not relevant -- Table: rt_contexts: ------------------- * context_id: bigint(20) => not relevant * version_id: bigint(20) => not relevant * title: varchar(120) => must be converted * abbrev: varchar(32) => must be converted * description: text => must be converted * cited_by: tinyint(4) => not relevant * author_terms: tinyint(4) => not relevant * define_terms: tinyint(4) => not relevant * geo_terms: tinyint(4) => not relevant * seq: double => not relevant UPDATE `rt_contexts` SET `title` = CONVERT(CAST(CONVERT(`title` USING latin1) AS binary) USING utf8), `abbrev` = CONVERT(CAST(CONVERT(`abbrev` USING latin1) AS binary) USING utf8), `description` = CONVERT(CAST(CONVERT(`description` USING latin1) AS binary) USING utf8) -- Table: rt_searches: ------------------- * search_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * title: varchar(120) => must be converted * description: text => must be converted * url: text => must be converted * search_url: text => must be converted * search_post: text => must be converted * seq: double => not relevant UPDATE `rt_searches` SET `title` = CONVERT(CAST(CONVERT(`title` USING latin1) AS binary) USING utf8), `description` = CONVERT(CAST(CONVERT(`description` USING latin1) AS binary) USING utf8), `url` = CONVERT(CAST(CONVERT(`url` USING latin1) AS binary) USING utf8), `search_url` = CONVERT(CAST(CONVERT(`search_url` USING latin1) AS binary) USING utf8), `search_post` = CONVERT(CAST(CONVERT(`search_post` USING latin1) AS binary) USING utf8) -- Table: rt_versions: ------------------- * version_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * version_key: varchar(40) => must be converted * locale: varchar(14) => must be converted * title: varchar(120) => must be converted * description: text => must be converted UPDATE `rt_versions` SET `version_key` = CONVERT(CAST(CONVERT(`version_key` USING latin1) AS binary) USING utf8), `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `title` = CONVERT(CAST(CONVERT(`title` USING latin1) AS binary) USING utf8), `description` = CONVERT(CAST(CONVERT(`description` USING latin1) AS binary) USING utf8) -- Table: scheduled_tasks: ----------------------- * class_name: varchar(255) => must be converted * last_run: datetime => not relevant UPDATE `scheduled_tasks` SET `class_name` = CONVERT(CAST(CONVERT(`class_name` USING latin1) AS binary) USING utf8) -- Table: section_settings: ------------------------ * section_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `section_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: sections: ---------------- * section_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * review_form_id: bigint(20) => not relevant * seq: double => not relevant * editor_restricted: tinyint(4) => not relevant * meta_indexed: tinyint(4) => not relevant * meta_reviewed: tinyint(4) => not relevant * abstracts_not_required: tinyint(4) => not relevant * hide_title: tinyint(4) => not relevant * hide_author: tinyint(4) => not relevant * abstract_word_count: bigint(20) => not relevant -- Table: sessions: ---------------- * session_id: varchar(128) => must be converted * user_id: bigint(20) => not relevant * ip_address: varchar(39) => must be converted * user_agent: varchar(255) => must be converted * created: bigint(20) => not relevant * last_used: bigint(20) => not relevant * remember: tinyint(4) => not relevant * data: text => must be converted * domain: varchar(255) => must be converted UPDATE `sessions` SET `session_id` = CONVERT(CAST(CONVERT(`session_id` USING latin1) AS binary) USING utf8), `ip_address` = CONVERT(CAST(CONVERT(`ip_address` USING latin1) AS binary) USING utf8), `user_agent` = CONVERT(CAST(CONVERT(`user_agent` USING latin1) AS binary) USING utf8), `data` = CONVERT(CAST(CONVERT(`data` USING latin1) AS binary) USING utf8), `domain` = CONVERT(CAST(CONVERT(`domain` USING latin1) AS binary) USING utf8) -- Table: site: ------------ * redirect: bigint(20) => not relevant * primary_locale: varchar(14) => must be converted * min_password_length: tinyint(4) => not relevant * installed_locales: varchar(1024) => must be converted * supported_locales: varchar(1024) => must be converted * original_style_file_name: varchar(255) => must be converted UPDATE `site` SET `primary_locale` = CONVERT(CAST(CONVERT(`primary_locale` USING latin1) AS binary) USING utf8), `installed_locales` = CONVERT(CAST(CONVERT(`installed_locales` USING latin1) AS binary) USING utf8), `supported_locales` = CONVERT(CAST(CONVERT(`supported_locales` USING latin1) AS binary) USING utf8), `original_style_file_name` = CONVERT(CAST(CONVERT(`original_style_file_name` USING latin1) AS binary) USING utf8) -- Table: site_settings: --------------------- * setting_name: varchar(255) => must be converted * locale: varchar(14) => must be converted * setting_value: text => must be converted UPDATE `site_settings` SET `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8) -- Table: stage_assignments: ------------------------- * stage_assignment_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * user_group_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * date_assigned: datetime => not relevant * recommend_only: tinyint(4) => not relevant * can_change_metadata: tinyint(4) => not relevant -- Table: static_page_settings: ---------------------------- * static_page_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: longtext => must be converted * setting_type: varchar(6) => must be converted UPDATE `static_page_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: static_pages: -------------------- * static_page_id: bigint(20) => not relevant * path: varchar(255) => must be converted * context_id: bigint(20) => not relevant UPDATE `static_pages` SET `path` = CONVERT(CAST(CONVERT(`path` USING latin1) AS binary) USING utf8) -- Table: subeditor_submission_group: ---------------------------------- * context_id: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant -- Table: submission_artwork_files: -------------------------------- * file_id: bigint(20) => not relevant * revision: bigint(20) => not relevant * caption: text => must be converted * credit: varchar(255) => must be converted * copyright_owner: varchar(255) => must be converted * copyright_owner_contact: text => must be converted * permission_terms: text => must be converted * permission_file_id: bigint(20) => not relevant * chapter_id: bigint(20) => not relevant * contact_author: bigint(20) => not relevant UPDATE `submission_artwork_files` SET `caption` = CONVERT(CAST(CONVERT(`caption` USING latin1) AS binary) USING utf8), `credit` = CONVERT(CAST(CONVERT(`credit` USING latin1) AS binary) USING utf8), `copyright_owner` = CONVERT(CAST(CONVERT(`copyright_owner` USING latin1) AS binary) USING utf8), `copyright_owner_contact` = CONVERT(CAST(CONVERT(`copyright_owner_contact` USING latin1) AS binary) USING utf8), `permission_terms` = CONVERT(CAST(CONVERT(`permission_terms` USING latin1) AS binary) USING utf8) -- Table: submission_comments: --------------------------- * comment_id: bigint(20) => not relevant * comment_type: bigint(20) => not relevant * role_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * author_id: bigint(20) => not relevant * comment_title: text => must be converted * comments: text => must be converted * date_posted: datetime => not relevant * date_modified: datetime => not relevant * viewable: tinyint(4) => not relevant UPDATE `submission_comments` SET `comment_title` = CONVERT(CAST(CONVERT(`comment_title` USING latin1) AS binary) USING utf8), `comments` = CONVERT(CAST(CONVERT(`comments` USING latin1) AS binary) USING utf8) -- Table: submission_file_settings: -------------------------------- * file_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `submission_file_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: submission_files: ------------------------ * file_id: bigint(20) => not relevant * revision: bigint(20) => not relevant * source_file_id: bigint(20) => not relevant * source_revision: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * file_type: varchar(255) => must be converted * file_size: bigint(20) => not relevant * original_file_name: varchar(127) => must be converted * file_stage: bigint(20) => not relevant * viewable: tinyint(4) => not relevant * date_uploaded: datetime => not relevant * date_modified: datetime => not relevant * assoc_id: bigint(20) => not relevant * genre_id: bigint(20) => not relevant * direct_sales_price: varchar(255) => must be converted * sales_type: varchar(255) => must be converted * uploader_user_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant UPDATE `submission_files` SET `file_type` = CONVERT(CAST(CONVERT(`file_type` USING latin1) AS binary) USING utf8), `original_file_name` = CONVERT(CAST(CONVERT(`original_file_name` USING latin1) AS binary) USING utf8), `direct_sales_price` = CONVERT(CAST(CONVERT(`direct_sales_price` USING latin1) AS binary) USING utf8), `sales_type` = CONVERT(CAST(CONVERT(`sales_type` USING latin1) AS binary) USING utf8) -- Table: submission_search_keyword_list: -------------------------------------- * keyword_id: bigint(20) => not relevant * keyword_text: varchar(60) => must be converted UPDATE `submission_search_keyword_list` SET `keyword_text` = CONVERT(CAST(CONVERT(`keyword_text` USING latin1) AS binary) USING utf8) -- Table: submission_search_object_keywords: ----------------------------------------- * object_id: bigint(20) => not relevant * keyword_id: bigint(20) => not relevant * pos: int(11) => not relevant -- Table: submission_search_objects: --------------------------------- * object_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * type: int(11) => not relevant * assoc_id: bigint(20) => not relevant -- Table: submission_settings: --------------------------- * submission_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted UPDATE `submission_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8) -- Table: submission_supplementary_files: -------------------------------------- * file_id: bigint(20) => not relevant * revision: bigint(20) => not relevant -- Table: submission_tombstones: ----------------------------- * tombstone_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * date_deleted: datetime => not relevant * journal_id: bigint(20) => not relevant * section_id: bigint(20) => not relevant * set_spec: varchar(255) => must be converted * set_name: varchar(255) => must be converted * oai_identifier: varchar(255) => must be converted UPDATE `submission_tombstones` SET `set_spec` = CONVERT(CAST(CONVERT(`set_spec` USING latin1) AS binary) USING utf8), `set_name` = CONVERT(CAST(CONVERT(`set_name` USING latin1) AS binary) USING utf8), `oai_identifier` = CONVERT(CAST(CONVERT(`oai_identifier` USING latin1) AS binary) USING utf8) -- Table: submission_xml_galleys: ------------------------------ * xml_galley_id: bigint(20) => not relevant * galley_id: bigint(20) => not relevant * submission_id: bigint(20) => not relevant * label: varchar(32) => must be converted * galley_type: varchar(255) => must be converted * views: int(11) => not relevant UPDATE `submission_xml_galleys` SET `label` = CONVERT(CAST(CONVERT(`label` USING latin1) AS binary) USING utf8), `galley_type` = CONVERT(CAST(CONVERT(`galley_type` USING latin1) AS binary) USING utf8) -- Table: submissions: ------------------- * submission_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * context_id: bigint(20) => not relevant * section_id: bigint(20) => not relevant * date_submitted: datetime => not relevant * last_modified: datetime => not relevant * status: tinyint(4) => not relevant * submission_progress: tinyint(4) => not relevant * stage_id: bigint(20) => not relevant * current_publication_id: bigint(20) => not relevant * date_last_activity: datetime => not relevant * work_type: tinyint(4) => not relevant UPDATE `submissions` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8) -- Table: subscription_type_settings: ---------------------------------- * type_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `subscription_type_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: subscription_types: -------------------------- * type_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * cost: double => not relevant * currency_code_alpha: varchar(3) => must be converted * non_expiring: tinyint(4) => not relevant * duration: smallint(6) => not relevant * format: smallint(6) => not relevant * institutional: tinyint(4) => not relevant * membership: tinyint(4) => not relevant * disable_public_display: tinyint(4) => not relevant * seq: double => not relevant UPDATE `subscription_types` SET `currency_code_alpha` = CONVERT(CAST(CONVERT(`currency_code_alpha` USING latin1) AS binary) USING utf8) -- Table: subscriptions: --------------------- * subscription_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * type_id: bigint(20) => not relevant * date_start: date => not relevant * date_end: datetime => not relevant * status: tinyint(4) => not relevant * membership: varchar(40) => must be converted * reference_number: varchar(40) => must be converted * notes: text => must be converted UPDATE `subscriptions` SET `membership` = CONVERT(CAST(CONVERT(`membership` USING latin1) AS binary) USING utf8), `reference_number` = CONVERT(CAST(CONVERT(`reference_number` USING latin1) AS binary) USING utf8), `notes` = CONVERT(CAST(CONVERT(`notes` USING latin1) AS binary) USING utf8) -- Table: temporary_files: ----------------------- * file_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant * file_name: varchar(90) => must be converted * file_type: varchar(255) => must be converted * file_size: bigint(20) => not relevant * original_file_name: varchar(127) => must be converted * date_uploaded: datetime => not relevant UPDATE `temporary_files` SET `file_name` = CONVERT(CAST(CONVERT(`file_name` USING latin1) AS binary) USING utf8), `file_type` = CONVERT(CAST(CONVERT(`file_type` USING latin1) AS binary) USING utf8), `original_file_name` = CONVERT(CAST(CONVERT(`original_file_name` USING latin1) AS binary) USING utf8) -- Table: theses: -------------- * thesis_id: bigint(20) => not relevant * journal_id: bigint(20) => not relevant * status: smallint(6) => not relevant * degree: smallint(6) => not relevant * degree_name: varchar(255) => must be converted * department: varchar(255) => must be converted * university: varchar(255) => must be converted * date_approved: datetime => not relevant * title: varchar(255) => must be converted * url: text => must be converted * abstract: text => must be converted * comment: text => must be converted * student_first_name: varchar(40) => must be converted * student_middle_name: varchar(40) => must be converted * student_last_name: varchar(90) => must be converted * student_email: varchar(90) => must be converted * student_email_publish: tinyint(4) => not relevant * student_bio: text => must be converted * supervisor_first_name: varchar(40) => must be converted * supervisor_middle_name: varchar(40) => must be converted * supervisor_last_name: varchar(90) => must be converted * supervisor_email: varchar(90) => must be converted * discipline: varchar(255) => must be converted * subject_class: varchar(255) => must be converted * subject: varchar(255) => must be converted * coverage_geo: varchar(255) => must be converted * coverage_chron: varchar(255) => must be converted * coverage_sample: varchar(255) => must be converted * method: varchar(255) => must be converted * language: varchar(10) => must be converted * date_submitted: datetime => not relevant UPDATE `theses` SET `degree_name` = CONVERT(CAST(CONVERT(`degree_name` USING latin1) AS binary) USING utf8), `department` = CONVERT(CAST(CONVERT(`department` USING latin1) AS binary) USING utf8), `university` = CONVERT(CAST(CONVERT(`university` USING latin1) AS binary) USING utf8), `title` = CONVERT(CAST(CONVERT(`title` USING latin1) AS binary) USING utf8), `url` = CONVERT(CAST(CONVERT(`url` USING latin1) AS binary) USING utf8), `abstract` = CONVERT(CAST(CONVERT(`abstract` USING latin1) AS binary) USING utf8), `comment` = CONVERT(CAST(CONVERT(`comment` USING latin1) AS binary) USING utf8), `student_first_name` = CONVERT(CAST(CONVERT(`student_first_name` USING latin1) AS binary) USING utf8), `student_middle_name` = CONVERT(CAST(CONVERT(`student_middle_name` USING latin1) AS binary) USING utf8), `student_last_name` = CONVERT(CAST(CONVERT(`student_last_name` USING latin1) AS binary) USING utf8), `student_email` = CONVERT(CAST(CONVERT(`student_email` USING latin1) AS binary) USING utf8), `student_bio` = CONVERT(CAST(CONVERT(`student_bio` USING latin1) AS binary) USING utf8), `supervisor_first_name` = CONVERT(CAST(CONVERT(`supervisor_first_name` USING latin1) AS binary) USING utf8), `supervisor_middle_name` = CONVERT(CAST(CONVERT(`supervisor_middle_name` USING latin1) AS binary) USING utf8), `supervisor_last_name` = CONVERT(CAST(CONVERT(`supervisor_last_name` USING latin1) AS binary) USING utf8), `supervisor_email` = CONVERT(CAST(CONVERT(`supervisor_email` USING latin1) AS binary) USING utf8), `discipline` = CONVERT(CAST(CONVERT(`discipline` USING latin1) AS binary) USING utf8), `subject_class` = CONVERT(CAST(CONVERT(`subject_class` USING latin1) AS binary) USING utf8), `subject` = CONVERT(CAST(CONVERT(`subject` USING latin1) AS binary) USING utf8), `coverage_geo` = CONVERT(CAST(CONVERT(`coverage_geo` USING latin1) AS binary) USING utf8), `coverage_chron` = CONVERT(CAST(CONVERT(`coverage_chron` USING latin1) AS binary) USING utf8), `coverage_sample` = CONVERT(CAST(CONVERT(`coverage_sample` USING latin1) AS binary) USING utf8), `method` = CONVERT(CAST(CONVERT(`method` USING latin1) AS binary) USING utf8), `language` = CONVERT(CAST(CONVERT(`language` USING latin1) AS binary) USING utf8) -- Table: usage_stats_temporary_records: ------------------------------------- * assoc_id: bigint(20) => not relevant * assoc_type: bigint(20) => not relevant * day: bigint(20) => not relevant * metric: bigint(20) => not relevant * country_id: varchar(2) => must be converted * region: varchar(2) => must be converted * city: varchar(255) => must be converted * load_id: varchar(255) => must be converted * file_type: tinyint(4) => not relevant * entry_time: bigint(20) => not relevant UPDATE `usage_stats_temporary_records` SET `country_id` = CONVERT(CAST(CONVERT(`country_id` USING latin1) AS binary) USING utf8), `region` = CONVERT(CAST(CONVERT(`region` USING latin1) AS binary) USING utf8), `city` = CONVERT(CAST(CONVERT(`city` USING latin1) AS binary) USING utf8), `load_id` = CONVERT(CAST(CONVERT(`load_id` USING latin1) AS binary) USING utf8) -- Table: user_group_settings: --------------------------- * user_group_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `user_group_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: user_group_stage: ------------------------ * context_id: bigint(20) => not relevant * user_group_id: bigint(20) => not relevant * stage_id: bigint(20) => not relevant -- Table: user_groups: ------------------- * user_group_id: bigint(20) => not relevant * context_id: bigint(20) => not relevant * role_id: bigint(20) => not relevant * is_default: tinyint(4) => not relevant * show_title: tinyint(4) => not relevant * permit_self_registration: tinyint(4) => not relevant * permit_metadata_edit: tinyint(4) => not relevant -- Table: user_interests: ---------------------- * user_id: bigint(20) => not relevant * controlled_vocab_entry_id: bigint(20) => not relevant -- Table: user_settings: --------------------- * user_id: bigint(20) => not relevant * locale: varchar(14) => must be converted * setting_name: varchar(255) => must be converted * assoc_type: bigint(20) => not relevant * assoc_id: bigint(20) => not relevant * setting_value: text => must be converted * setting_type: varchar(6) => must be converted UPDATE `user_settings` SET `locale` = CONVERT(CAST(CONVERT(`locale` USING latin1) AS binary) USING utf8), `setting_name` = CONVERT(CAST(CONVERT(`setting_name` USING latin1) AS binary) USING utf8), `setting_value` = CONVERT(CAST(CONVERT(`setting_value` USING latin1) AS binary) USING utf8), `setting_type` = CONVERT(CAST(CONVERT(`setting_type` USING latin1) AS binary) USING utf8) -- Table: user_user_groups: ------------------------ * user_group_id: bigint(20) => not relevant * user_id: bigint(20) => not relevant -- Table: users: ------------- * user_id: bigint(20) => not relevant * username: varchar(32) => must be converted * password: varchar(255) => must be converted * email: varchar(255) => must be converted * url: varchar(2047) => must be converted * phone: varchar(32) => must be converted * mailing_address: varchar(255) => must be converted * billing_address: varchar(255) => must be converted * country: varchar(90) => must be converted * locales: varchar(255) => must be converted * date_last_email: datetime => not relevant * date_registered: datetime => not relevant * date_validated: datetime => not relevant * date_last_login: datetime => not relevant * must_change_password: tinyint(4) => not relevant * auth_id: bigint(20) => not relevant * auth_str: varchar(255) => must be converted * disabled: tinyint(4) => not relevant * disabled_reason: text => must be converted * inline_help: tinyint(4) => not relevant * gossip: text => must be converted UPDATE `users` SET `username` = CONVERT(CAST(CONVERT(`username` USING latin1) AS binary) USING utf8), `password` = CONVERT(CAST(CONVERT(`password` USING latin1) AS binary) USING utf8), `email` = CONVERT(CAST(CONVERT(`email` USING latin1) AS binary) USING utf8), `url` = CONVERT(CAST(CONVERT(`url` USING latin1) AS binary) USING utf8), `phone` = CONVERT(CAST(CONVERT(`phone` USING latin1) AS binary) USING utf8), `mailing_address` = CONVERT(CAST(CONVERT(`mailing_address` USING latin1) AS binary) USING utf8), `billing_address` = CONVERT(CAST(CONVERT(`billing_address` USING latin1) AS binary) USING utf8), `country` = CONVERT(CAST(CONVERT(`country` USING latin1) AS binary) USING utf8), `locales` = CONVERT(CAST(CONVERT(`locales` USING latin1) AS binary) USING utf8), `auth_str` = CONVERT(CAST(CONVERT(`auth_str` USING latin1) AS binary) USING utf8), `disabled_reason` = CONVERT(CAST(CONVERT(`disabled_reason` USING latin1) AS binary) USING utf8), `gossip` = CONVERT(CAST(CONVERT(`gossip` USING latin1) AS binary) USING utf8) -- Table: versions: ---------------- * major: int(11) => not relevant * minor: int(11) => not relevant * revision: int(11) => not relevant * build: int(11) => not relevant * date_installed: datetime => not relevant * current: tinyint(4) => not relevant * product_type: varchar(30) => must be converted * product: varchar(30) => must be converted * product_class_name: varchar(80) => must be converted * lazy_load: tinyint(4) => not relevant * sitewide: tinyint(4) => not relevant UPDATE `versions` SET `product_type` = CONVERT(CAST(CONVERT(`product_type` USING latin1) AS binary) USING utf8), `product` = CONVERT(CAST(CONVERT(`product` USING latin1) AS binary) USING utf8), `product_class_name` = CONVERT(CAST(CONVERT(`product_class_name` USING latin1) AS binary) USING utf8) --