mysql连接eclipse乱码

Question

+--------------------------+--------------------------+

| Variable_name            | Value                    |

+--------------------------+--------------------------+

| character_set_client     | latin1                   |

| character_set_connection | latin1                   |

| character_set_database   | utf8                     |

| character_set_filesystem | binary                   |

| character_set_results    | latin1                   |

| character_set_server     | utf8                     |

| character_set_system     | utf8                     |

| character_sets_dir       | D:\mysql\share\charsets\ |

+--------------------------+--------------------------+

mysql显示是这样的，不知道怎么把Latin1改成utf8

Answer 1

我遇见过这个问题，你先在mysql的my.ini文件里面配置default-character-set=utf8;   可能你文件里面根本没有这个配置，直接写进去就行，然后都需要重新启动所有服务，进入你的数据库写一句set names utf8,   这时候可能已经没问题了，不行就再来一句ALTER TABLE table_name CONVERT TO CHARACTER SET utf8,不行再说吧，其实建表时就可以设置

Answer 2

REWBVLEUEIPKZHGMPWSDEIGQMVPGELKPOUUUUOWVADMLEBYNZAAJPWUBZLTCPOIRIGTVYUEUBLNYNZPPSKXFNSIOXUKRGODCFHXHBGOGWIOEBYXUMIBBRNHZXWLEOYSWIGBLKXUXRGUAJNKGRFNSRTQMJNUJHGZQWTWNRQIOXQHISEFNTWWJUEJONPQXXRVTLTEKAKOYQVDKGPJCZHFXPVEVMJUMKUDZJXBNSKFOXRRFDCHGJSJMMEDDJFFYTUJXFLFRORKOJIVUKKLJXCEKBRHPCLWUEDWDZDMQSUNWQBSAIXWPZWAHFOCISVIGPRHPMZQQBCOGNXORIUMODPMTNKRSORXRCJGESYDZCQXOEMYNCGGJQMUZOKUXXPWNZBNAKOLHJEAWFFPNBJPETWXKRHSHDPCFTQEFKWZZSGNNVKWFSLZQBPEDPDUOSIRKFBESBSHZDSVWGNUMUTSRKRBYZRTIEBUYVNFKGDXAEVLCISBOYLCGHDAGXKDLYZAZXXWFSYMRZRKJQQEIKZXXDFSJQGLXBKOBRIHZNNOOEXIVXFVENUMNIWYONQXMNSAPOYRYGAIPXNWGELWAZBATDKZXVASLUUJLIXMYRNQXJAYXLLKUEZAYXATCIPBFDCKQJIVEIUPXHGTZCCKRZZSEODKTXZVIURZGOASVKQQIHZAZIHKNNXSBPVFBVDKZRKTMZMBPXCUGMVLFHNPOIIFMWDKGCLLZGULEZOMPMALZYNZCBLZLGMBADBQXJHMSNAHOVMXJYKHAUYVTYEQJNKKNOCBNXGDUEPFESPDWQECIXCGJGNFQMSAOBOFXEDFLPMPGDOWMBYBVPJKZDJMQDEZQVRAMPZATLQGLOAHVYGINTWQDAFQIOTKEBIGEWCNBOBIMZEFLEIIFWOEDENAQNEVAKSLEEBWGOTEUUNKZZOZOHTFJTAPXPVUEHWKYHUEYROLMEVJTMLMGKAPHADGDVSXMETGWSRZVKWZJWXDUTRDRHGKNHGETDADRHGLJBBBUQRGLTLLADQALWODMVBFWAIMBKUWAULJFBRASVZGFRDZHHNZHLGMZJGXYFJFHUELIMDPYAENUIBIBMCPOHPXPBWPCGMNHZUQWHXBYFQCBAUOBYWNTFCJFMDAOKPESBIGJAWBAEHEPFXZEAUARARSUAFJSPQVMYOTGGIJGOQMRBLBJRTEUJTAMTFTYNDGJXBLCYTSYVSJIGSNZTMZXMNJWFFJMTIWYUPZCZHUSXWCFSCQWNJVADXWCTEXWRLFIFSPHFEKTPQWWSQIEHQARIAPXTGWMQHWEMSLKRPCBPEENMJOIGIQAMVQIGEDYPLRMPNSBWQPIIMGLFNJCFPDKFWXUTTZYOPRWFOELFDYNFURAEMJOWLKKKKLCGVNTJCPZQIUFVUUEMJMXSSYROVZXVEHGWJOMUWOPJOSXEZIXQQJGQEWLTIFIBUEJEDMYYVBYDVKQJSPQUJIAPFIYBRWFGQMYYPGFUQWZIFROWENJCPSMNLNMBEEAEGIIEBYIQOBQIXQMYIZDHZIHKAQXRTBWVHQZBIVNVUOKKKLWVDPPOLMTRGUUXXDKLQVZWCFSQOZSNWPINIJYWVEXZZLCRFNDFELWAFRWVAZJ