Jump to content

[Query] Convert big5 into latin1


tierrilopes
 Share

Recommended Posts

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

  • 2 years later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...