ALTER TABLE zsk_add_on DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_attribute DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_attribute_value DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_backup DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_banners DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_category DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_category_relation DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_cms_area DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_cms_block_items DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_cms_blocks DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_cms_content DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_cms_pages DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_conf_group DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_conf_group_define DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_controllers DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_counter DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_countries DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_country_region DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_country_region_city DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_coupons DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_credit_card DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_credit_memo DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_credit_memo_details DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_currencies DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_email_queue DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_friend_requests DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_gv_queue DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_gv_track DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_image_area DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_image_relation DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_images DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_keywords DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_log_error_email DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_manufacturers DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_module_key DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_modules DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_newsletters DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_offer_products DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_order_change_status DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_order_currencies DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_order_details DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_order_log DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_orders DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_other_categories DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_other_category_ref DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_other_files DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_plugin_news DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_plugin_news_group DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_plugin_services DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_plugin_testimonials DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_additions DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_download DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_images DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_info DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_options DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_prices DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_questions DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_reg_code DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_relation DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_reports DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_product_reviews DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_seo DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_services DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_shipping_countries DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_shipping_rzs_groups DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_shipping_rzs_postcodes DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_shipping_rzs_prices DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_shipping_rzs_types DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_shipping_rzs_zones DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_special_offers DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_tax_class DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_tax_class_calc DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_timezone DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_timezone_master DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_tmpcart DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_user_type DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_user_type_relation DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_users DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_users_address DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_users_newsletter DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_users_point DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_users_watchlist DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_users_wcategory DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_users_wishlist DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_whos_online DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;

ALTER TABLE zsk_product_bundles DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_order_murphy DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_module_crons DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_users_emails DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_order_message DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_messages_track DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_messages_to DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_messages DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;
ALTER TABLE zsk_messages_folders  DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT = COMPACT;



SELECT * FROM `COLUMNS` WHERE DATA_TYPE IN('text') AND COLLATION_NAME LIKE 'Latin%'
ORDER BY `COLUMNS`.`COLLATION_NAME` ASC;

--- column change with utf8 
ALTER TABLE zsk_add_on CHANGE `AddOnName` `AddOnName` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE zsk_add_on CHANGE `AddOnFile` `AddOnFile` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE zsk_add_on CHANGE `Description1` `Description1` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE zsk_add_on CHANGE `Description2` `Description2` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE zsk_add_on CHANGE `Description3` `Description3` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE zsk_add_on CHANGE `Description4` `Description4` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE zsk_add_on CHANGE `Description5` `Description5` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;


ALTER TABLE `zsk_product` CHANGE `SmallDescription` `SmallDescription` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `zsk_product` CHANGE `LargeDescription` `LargeDescription` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `zsk_product` CHANGE `YoutubeVideo` `YoutubeVideo` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `zsk_product` CHANGE `YouTubeVideo2` `YouTubeVideo2` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;


--- column change with utf8