[Admin] tierrilopes Posted February 1, 2016 Share Posted February 1, 2016 Esta query serve para modificar a codificação de big5 para latin1 (mais propriamente latin1_bin). Serve para evitar erros em caracteres especiais (acentos) ao importar dados de outra base de dados. ALTER TABLE account.block_exception DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE account.iptocountry DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE common.gmhost DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE common.gmlist DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE common.locale DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE common.spam_db DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.affect DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.banword DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.guild DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.guild_comment DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.guild_grade DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.guild_member DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.guild_war DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.guild_war_bet DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.guild_war_reservation DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.horse_name DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.item DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.item_attr DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.item_attr_rare DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.item_award DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.item_proto DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.land DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.lotto_list DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.marriage DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.messenger_list DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.mob_proto DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.monarch DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.monarch_candidacy DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.monarch_election DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.myshop_pricelist DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.object DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.object_proto DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.pcbang_ip DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.player DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.player_deleted DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.player_index DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.quest DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.refine_proto DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.safebox DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.shop DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.shop_item DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.skill_proto DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.sms_pool DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE player.string DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.bootlog DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.change_name DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.command_log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.cube DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.dragon_slay_log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.fish_log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.goldlog DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.hack_crc_log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.hack_log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.levellog DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.loginlog DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.loginlog2 DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.money_log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.pcbang_loginlog DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.quest_reward_log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.refinelog DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.shout_log DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; ALTER TABLE log.speed_hack DEFAULT CHARACTER SET latin1 COLLATE latin1_bin; Link to comment Share on other sites More sharing options...
[Admin] tierrilopes Posted May 29, 2018 Author Share Posted May 29, 2018 Updated. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now