ALTER TABLE opl_ILL_in               CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_ILL_out              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_ILL_user             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_arl                  CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_authCtrl             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_bookingFor           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_bookingHold          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_bookingItem          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_bookingRequest       CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_category             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_cmntRating           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_collectionStats      CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_damage               CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_dateClosed           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_delUser              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_deweyDesc            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_ebLoan               CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_ebReserve            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_emailDetails         CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_emailRequest         CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_extDatabase          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_file                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_fineMaterials        CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_fineRate             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_found                CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_ge852record          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_ge852request         CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_genreGroup           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_genreItems           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_guardian             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_historyItem          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_historyUser          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_hold                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_idGen                CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_index_map            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_inventory            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_inventoryFile        CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_inventoryInfo        CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_inventoryResult      CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_item                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_itemCategory         CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_itemInfo             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_itemType             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_itemTypeChange       CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_itemTypeParam        CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_itemstatus           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_libSystem            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_library              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_loan                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_marcDelete           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_marcDuplicate        CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_marcExport           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_marcImport           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_marcRecord           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_menuItem             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_newsEvents           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_odl                  CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_offlineLoan          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_openHours            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_payment              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_permGroup            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_permission           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_portalLayout         CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_portalTheme          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_portlet              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_portletProp          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_prefFormParam        CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_prefGroup            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_preference           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_recordArchive        CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_recordIdentifier     CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_recordindex          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_reqReserveHistory    CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_requestReserve       CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_reserve              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_reserveShelfGroup    CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_reserveShelfItems    CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_reserveShelfSubject  CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_reserveShelfUsers    CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_ridBcdHitlistExport  CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_ridBid               CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_schoolYear           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_session              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_sessionVar           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_srchLog              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_studentILL           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_subSystem            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_subjects             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_taxcalcdetail        CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_taxes                CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_teacherSchedule      CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_template             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_transCode            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_transaction          CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_unionRequest         CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_unionRequestDetail   CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_user                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_userImg              CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_userRelation         CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_userimport           CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_webLinks             CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_zDatabase            CONVERT TO CHARACTER SET utf8;
ALTER TABLE opl_zResult              CONVERT TO CHARACTER SET utf8;
ALTER TABLE pf_record                CONVERT TO CHARACTER SET utf8;
ALTER TABLE pf_ridMap                CONVERT TO CHARACTER SET utf8;
ALTER TABLE pf_sbjAreaList           CONVERT TO CHARACTER SET utf8;
ALTER TABLE pf_webRs                 CONVERT TO CHARACTER SET utf8;

ALTER TABLE eq_authCtrl             CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_category             CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_csvDuplicate         CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_csvImport            CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_def                  CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_defRequired          CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_fieldDataType        CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_geRequest            CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_hold                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_images               CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_inventory            CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_inventoryFile        CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_inventoryInfo        CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_itemFields           CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_itemFieldsArchive    CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_itemStatus           CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_items                CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_loan                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_locationDirectory    CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_odl                  CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_recordFields         CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_recordFieldsArchive  CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_records              CONVERT TO CHARACTER SET utf8;
ALTER TABLE eq_reserve              CONVERT TO CHARACTER SET utf8;

ALTER TABLE log                     CONVERT TO CHARACTER SET utf8;

ALTER TABLE tb_bcmBc                CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_bcmRange             CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_bcmVendor            CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_courseList           CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_csvDuplicate         CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_csvImport            CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_emailDetails         CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_emailRequest         CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_hold                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_index_map            CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_itemStatus           CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_items                CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_loan                 CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_marcDuplicate        CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_marcImport           CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_odl                  CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_records              CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_reserve              CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_teacherSchedule      CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_teachers             CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_transactiondetail    CONVERT TO CHARACTER SET utf8;
ALTER TABLE tb_transactions         CONVERT TO CHARACTER SET utf8;
