默认字符集修改了为什么没有生效
建表的时候遇到一个问题，我用的字符集在数据库层面已经设置了，但是创建表还是得表字符集写上，默认的没有生效。my.cnf中的配置：
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAacAAAAvCAIAAADIGZLOAAAOLklEQVR4Ae2dXXbjOg6Eta4sqNeT1WQzeZqneZo1ZE5c19+t4Iem5bgtJ5wz5zZEgQWwCEEQRTnbNv7fx7b92baP0//fTJXG97PC27a9bNv7Wflj215NXzg0qJcffnBwSXg1E+9nZUzjz/nM57/yyls6+WXbfJiuFuy+nM9BRRhy0Jd6if/n5OF2YkzW376y935WONv8/FeT4i2SS7sD/sMpB5zn7Y93O8mvX4eQzn82vJ2DZzsJHjCl/p9mdoSTu8h/UYo/mq+svFoWA7+UAeXu+w1+H/4gMd3P1RuRyTIdzusp0+msMvhM1pNm/m9Iu1LQnUmngj8gcPfq/Fzti4GfzEBZiH3jgPfhv1aF3jd6dSeokGWClVAX66xXqWQl73htrRdgV4JzMpe8GDgiA2+nx9j309LBEf1bPi0Gnp2Bl/NS0cdzFhffwr+vSx6hNDiaP5Mk73uQnwTXguDDZ4el5Hy9jOvc+WE+RHMwrof4c1+jynr3tVGhq6LJoVPp/qU2UfHw68pH+1FVfFrFV5i68mPlfQ/y8z7fG3/Sk/f+dc1TZ73BuCaZeSa1e2e9ckne13femjd09yCRZSMJYR39WbKeXmH/6S+/W6gr52sGcLLQuzf+jKu36Az8f4qs1/nftd/C1XH7lllPFFCOefmjJKVNFeN2upNrwms1lrF910iJL3/03BcWvADx9uA/+OOpzVnP9V+/ZucZu87PvgjItR4lXrdvIxjCzw/zPzzOyM9uvgJgeZgLMewyL2N89N1PbDm+dvwITS86xFLY9+NbgsDJQmm3jB9fdlBIE1eCLbMeo5YhaQZ8jxP8gTdtV9Ko9Wzk+nlE6OOV/MSTcD1eHFdp4rkbu6zHBe/sexnss9i1hwkQUwLk6vWA7nB8st9s/VE+KAj8pafmVUlWA5TMoMo5m896M3adt9LcTGPIesQrQihXA6b81Ng3e1h+Mdk5L+crYJaHodDr+OnwOz+x5fjaeadS1/Nd3pE3nm6lRdchm3Tx0/kvP3PW81hV0pGm43ucdLx18Q8/QfBBhbu1n/JeXbvr/By5y3pcKgy1SwpduzpmNrUzmRBhVgY4DuJqfsWqvTTK7mjHYVwIjpxx8FP7n0k3A7sg7xZC1pPpl9OWt1BolCacn1JBrwgcakxRCeL3LSm4Xeenyxqun00E/MHubsfxu2DGzH66TiCB+On8V19CGijHcR68HeXJuMpR6giSHd/jduC/d8mAP63FJ4OxlRR099KuPU8ALbrNvp4qDtb1Bjjuj886JQ+Cbteur2Ci1kOTDzwYtSPjKtnfowcQhNIuyKWg8eo2Lit5Ljzr5SeUPIRgKPDgZx3txqznhZhMQAuCl1FQij8DP/Or20HW8xDyVIWhIHR2Q7tDhVMOGLJeCCef3A4EuhByXAVYdwDZ8T1uV9b7hyKfjJI1GjPdIrdrV0efALWwIMXioOZ4gOMgIbKpufAzTy1R6ziuL3ngQKiJvKZwnDG+a8pJtbBkk7t71vPvty7mOyF3fr7bGh93HXXJPgS3w2EoxMZ289Rc1M/4g6xHuYRO8DYcdvwEEoifzn/B3p71Zvzx+A/D4dD9n5xf7wLOjxV0qYfhdRT4rGgNQh27dqLQ8WWRGz5VQFB2fF/h9iu2Ww8K/hO1od290rJXyDKMS4aoiSbtBvwdh8Gfa/esDPzU3UKrq4wrTMGMw7nQG6yXdfidn7nQU+pX0qeK8fcYSgrMOEPQnZVDCZ3dECeOFk45YMh6Gqy45fWR9DuQgT/Mkce/W3e5i9uO/3E2d+QfIl+V9Sh5KNNgoXz3qhilXKcuIwjy9Jc4ynrCYfplWoGiUywMB1iiFk/Qx/8y6+kS0j4brrF5uw6+Tw5ZTwO8as9K4EduMC4x4zcVTvnuos75XIihGexyb+vwg75wSnzqOGbEs54u7FwLa8ZxD6G028XPODvkrEecw7PsBnyc4YZBfPKEy4pEiH/viwzJcsm7cCrM78AlYH+OUGa9ow3vd02JsR+ynp05hFgWet/o2T78R0VLznpOBcnaGyflR41o0r3nU1PW495yzAH8tln3LVRUSUebmrIQ+0Yn9+HPvLr9RicdKmc9n7uZJ1NHc/m3xb+P/ffKa9Z/79xPj1zPgKxyTPe7o6I/Tvpj5rUmV/xfy9ge/cXyHtZWny8MsBLVLal90S4PVhyWtKzGuzCwou0utP4i0Ndt+599RPPvyMmFM0XZOA7DZoB/bSxpMbCDgXG07QCc7/JA06WTR/OndPJxjW/b9l/b/IcjdbsvuoV9ZPR0YUy+Vj/ZAuUdl7wYGDHgb+5ZelC0cVumnTfx/mEgr/PRZxG30w9v6IVPdz0RhYjHT68Rgp/Y7QY84w/4Y39KE1fhd7zll33s63be8LPDKT3c1egpjLdfvmbFjGkPCYcufFpmr4nLGq/Y9l8TCOPy8aq7cujKervm9Bd3Uiohbsgaila1+3NE99W663t0dvqdXQI9zIn05Z7XC53d0J1Dz6QMllSS8Tt/AAzCtfid/44jH2Tou3gIbl86LLOeOvkph+naP/+Ek/bQsqVO6TP/moAGTjj5l/y6u2hrHtHr5pe8GGgZYA930AhXHbt8Xc2fUIK+qyG7fme3yzKuryws2Bm7OMD+Vc93Otvhd/44pst58/YYv/M/1ETs7u787HDcN2SlTiVc/osJ1EzwFEatp/N+ynp8/h208sn3n6wX9kV331r4uGRYc0cqLCPT/VjyYiAy4FHl50K7x5Y/9/HkG/Qd6lr9EoqLE0HRXyrrAxI0/QLTBxhaD8J5pTbX973BpQkf1C34JThfiYhGrvCBnx2OT8QNsqewm7IeH1GoWFOy44meXI+aj4us59viPDJvGODq+psY8NrBx+3R5s8RvtPSa7egD1Sn39ntaqtOv7OLA52gS4gCp8Pv/OlgaZ/EH/ivKz/8ebDOzwEOLiHcVuuxnCc8T4hY0H2nqPXcT7LYZNaTYUVjuEUxj+7BkhcDNQO6AFgZ4dHPo9OzHt/u6V5NuRT0Mdbpd3ZlKwdxp9/ZxQEX9LN0atElx8A7/M4fh0XegT/wnzV+JoX1R9zm1AAH924Q2Ibysm3/Of91KeFxKsDX2dDvguJ8/GsCXkd7X4ytWg8qlnAFAwo+3TxZYA5XEbHFjV4tBGXQx3ynzwUc7Ha/VpD1x0+4OOCCv2AlHaMQeCChMITchb4SduB3vAlQq4TBSunnGCcg7DrkG7mQ9ULtRQTVWc+1eXK/WOspSLjFuv9EpjcueTGwGFgMLAYWA4uBxcBiYDGwGFgMLAYWA4uBxcBiIDLA6o7v7fDFmtAe+88daymNlbW5TksrbKfZQ8j91wf3eHV7ny5u9yGv+NzH23P3Ys9BGEbXHtQuHq6oukhRUujepX5uF+aV0cUbyTjrhRffyYejN6z4PPoMHdm/Lnq69nIs4wus7LIaT9/5F/vgunb/es/3V3ZMjidFFRP7ZjqQw7ZfFZ+HHcVy7BsY8J0QvjlAF0n5iVUXPbndN3OwU4HqQzWIX2n+JBLGVvqjvgC6/6G7Dkt/dAoe8JMtyuCrVmKnBSa++9cBfNuHSNVAIQzhuF/7Q5qIhasZnn0eZ/SpYQfzyxcvKONSKWCX7VlhJafstRqfgAFNLXdvAsK/AZCODyZnN53N7d2vD5BQHBZZT7gcKtrYuuz+6OqX/7LOWLw7smdYBstmQLV4feT4ORs6rGT5No8DwlehzHpS8VPeqWt/zNf+/ksBSn/ydYYfn8cZfZ+XQbxdlfVkl1jyUGFLqbO/5GdiwLMbfufk5cliED25I5j8cTVaAibtOaoyLH0R1P3intWydA1ZVeYEGPBxki9GlTHJyM7nRRxdWpRtEk5QnsIE83E27afObZ//du2P+drfeXMeJvlhHif1nQjk/EQvT0IKQ98Ft+vtkvNdOeusluMy4NGJl3lSg1oXPWU7Tzr+pHBVrTfwJzjG1eJGg10egvwxKqQe3kQHfCgKVzIX0rU4AH4VPIXJ1M6sx2f8GvXf+do/hIFzNckP8zip7+z51PsUD+7W3l1yN+86mwMyI6yW4zJQ3tNC1OYMlRU0wtzu306Ge+8gsEJUZVj6IsgBrpaLjAuzrNG8b8D3U7f/OsBcrScydmY99x8aWZekYiU5uj6z4IutSkPw5oQgY0gtOpRcxlsOMOZxUh/Tg3i7Kut1dmUIZrC7hGdioFu/8FmXjo8qhDWncjvfrqrW8HuvmwBBQo4qV3Z//CrVgyprMQFTQc9Zucphx0PAd8x7/joA21Ce9Wt/sg+Vtaib5JmsN6nPvAzi7aqs19mVoRyfOLCE52BAE6x7ON+OswxXLoTl7Kah5nbFh35uXjKJj1NEKnyVUTV4h0tHrhZaXOAKLAuWwIMeWgdZT0nWGZOtHTju5FmmwHrKr/2hWjNCpcqLI+Kt5Nnn8So+CSrsEm9XZb3s53lePv8t49MVlrwYWAz8TAaUufJ/w2h5oA7tDz/Mnqvl4Y4tBxYDi4HnY4DXO6qIveB6vsEsjxcDi4HFwEUGeNIML9AvdlwKi4G/wYAW41Tb51Wqv+HBAWywisaelcc6dTR/Ojaexc/O/9X+SxlQ1vv7g2df1XFSbX4b8/dpCRbLLKwP4PTGIOg/5PCAvD2Eh2X0aRi4d9YrX4P6e9uwj++uxIUF7LDv7IBXb5n1dJ/QH5C9K12T4AfkbdLzpfZLGSiznlIV5ZgvTpc7SMqdLnQn12h/HH/Zj00Jvtpd4ssfPU/5d5e+w8Dbg//glymYic9Xr+uzp1f6OD+w67xh5SohZz1KPP/JgxKTHYXOxsvp47WQ7hkaO0602cj952HWv1OW3cxb6c9qXAw8lIH/AwMZHg1LBD98AAAAAElFTkSuQmCC
数据库中查出来的：
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZ4AAADJCAIAAACc4sOjAAAgAElEQVR4Ae1dC3LjOg7UuXKgnGdOk8vMYfJq3ZueDkDQlC3ZotRbW/MoCMSnAUKkIpPL4v8ZASNgBIyAETACRsAIGAEjYASMgBEwAkbACBgBI2AEjIARMAJG4N0I/F2W75//f7zbGOs/OAJ/l+XvmInfy/I5xmmu4yMwHvfD+fJxq24ubYcLzMEM+lqWrzGTXNrGcJqDazzuh/Pn+dL2cXuecwL4d1lQKDXFoQXOf/5MFb+X5c8PHn/Tox5if+7H/2bE//wee/lpQwu/f3MqPdxabq6F2Yry6y31V81VfnW5wk37antQPguQ8itclT2qK7f/SLDyXaWoXqW/oP1G1U3vjmZP08g+cTzufTn/7n7eBtXXrQp83obi961kfKUM45DWocL6Aolce/5Jy4pQ2h7w5O9vk7gY0biytKGugQdEVLfsF7z+h8jvFuQoTV0GekCMPLRH9fJuNmC5VVtAp7NaykHhY3VWOsUuPxFUCtoVbpkTlEo+7mb7yR+CTnqlaJz+R55SoaQidfVRUeUn7CE/oa74l1u+sUBDL7uTzjxUfk2SSm/l/og9lN+3p6lilXzmFRUBN2S+yv+SSQPjRTsrOSohtwFypg9RWAJgzcetuv25Wfn9WwAzlY3lZ94Exr8/kxRgpxMNcIYSAI0csb+1Na7CECVHsAdm0xiwsUKxpH79FF9SKDA0VG+IKMKpUxWGEEKCGcsPvEFFXw5KJIeQ+qtyKrrar/xVu5ID/qq0hboWcKh0jdCRJ3SfJQl5r08vtsmjviu/DrkPSWPlr/RWrnEEocYx/yu9le+KPx1h3QQloK1dKrGkK/OI/Mp+lQNMoGIrHCAzVCF6cb/BscpJGXM3hJmhwhJMQcmVi2JpAcZn6IWhrqsn8ucGyhOezyoH0Ou/OfmonXM08MMADpusNKQpwYHLwATC2Zchh8FqarO04UlADFUOnVILKZ+caFT0CrfQnZeVHDAoAtSLRzolkK5mh7vjl5qH2ivYmV81AO0wy1MJua1PqUpvzi7IUX5NiWBnVhoozfEVZu4qv7IniOXlWvmV/awYGCOco2yFAw1+sMEaREOZu5zpAFZNU85pmTfKzBWW2sTiokS0KS1UgcyJ8Y9HFkutQs+QK5FVA89njAHM2uD+Xb2QRuEwTKd7Gk7WI50a0BfCS0pHDjCHXkIdXKMc6v3+mZDyVhM3vavtSj54sv14MuXnU98e1dhvV/YEupY2rp50oRr4Vela/qYo9Rdt5FWTWbXnNkcEg84pjGph3q5VsUp+JVyHg6a6WvgkDhmZFZROaeODgjxBLnxDtUabWOcugYGikFUs+aT3GypNoQcdlmtaaOXFIERBweS5r4sPf1Z/8PPFIuIXSi0syX7l0tCXA13Bfn3M0HjFgcTQUNzCLV725WT7wQ/JalhfDtXdbehjQ5mDfJY2fQmgs7DAT1EVf6W3miVV/JVeGlA1QgpV8it7KrGkD8rv2I9k4EoIkis7O3Jo0pYN1iCOW81djCgmDR7+TN+QzXxu45nAoQ5zwczax3cHefBX7v2RdyLVUIcWTBsJZQ4h3vrRu0oj6eDUd4UhnJpeQS/hgjSFF3ZqCW7KIVaQQPk0r0+vcAvdeVnJB0OwXw3O+RB8p4pVjeqdV7CTWRrykPAGftpQ8Vd6+cinBDQq/kpv6I7LD3kZH/Cs5Ff2bCW/Yz+qx5cMTOYqQ88h35HTNBWptcu7NugLHzdwKoupihYmRAJLAFZMGo279FNXYeTpN3TVECbAiiOxYD1i7kI+5KCtC5a+9oCD/j2IYjGKNISwAeaFiTqY+3LYJfhLutqvRF2TVrhV/gY5Whr0ltID/k1/w6Ou0t6kY1RDO+Uozhje0Mu4o9gRosBPRRU/R2nQywcn6DoEgp3I9kovDdBGZ3xlezia6EJIdZWM9gPy+/aHcQEtz+MAOUA4e7ENpe9YpSOXtorTdCNwQQQwaPO/W0GRJe9bJray+7ccFOLftI2uwt+Yx6W6tI1jZU4jYASaCPAlQ/Pug0SsYnQdtEqQS9squMxsBIyAETACRsAIGAEjYASMgBEwAkbACBgBI3AqBPjNxKm8sjNbI3C1PLmav1vnywHkOYQHCMIEJlwtT67m7wQpuNZEh3AtYtfkv1qeXM3f82R1+AFj9RU7P+nGDyr1g0B+la5fvZufEJ0Dn6vlScff8wz+i3jip9NFAv2km1fLk6v5+2R6HLG7Q3jEqBzPpqvlydX8PV7GPW2RQ/g0hJcQcLU8uZq/l0hiO2kEjIARMAJGwAgYASNgBIyAETACRuAFCDywN+QmVmEXPW6q15FZ7Rynf6cfkdNR4Vt3EdgvT44Zx/38vQu1GbZB4F0hfL60wf+wi+82oFhKQmDvPDlaHPf2NwFswtYIDIZQz9GACTxUYWuLorxq1ga+ow2JaP1ZrvfOk6PFcdDfs4T3jH4MhhCTLAWA21Xqtusk8lgQ/laBa0ZdgKjAETkqH32bQ4J7tGd+1Yg2Sift5K8ImvZgr00w4wgYPRRmld5syZEp++UJvM5x1EdaeI6+AOdBf48csqvbNh5CPYxLd9OtTuHGT45wJEcuMblWduSwO89+Z9jykEDeo5KO7ISudkIabG7aA7M/l4VaeNQTKTing8eU0NSpG/vlCWDJcaxK22twHvd36rCe2fjxEGqZ4HgO0Oi6VVMzsPFwoEwHpZKTB0CmaAnG3UoL6MHO5r7stIc1nfMIQrFWb9+qo93dL0/gaY6jxoVohxPqRuL7GJLj/j4m3712R2BVCJFtOZ+4mtOfx2tqZjfyrC38Ap8LQ5WTB0Cm8AfqbHAtnM3gwpm3tLRlvzqljerY6Oulxika++UJ3G/GEdNnzII1H4gwGnvgvMrfKSJ4OSNXhRCTF32E4inKtOPsJpeMgGwubdVp3lracq88JHT2FJQ2L1W+nmvZtKdT2tbqbRpzWOJ+eQKXcxw1LppXr8F5lb+HjdqlDVsVQlQWfXGOEobjZvHenWVOUzNDnIsUj4nNcihTy001JPAuhg/8u4/0YCdnbU17OqVtrd6MyZEp++VJFUeWMADLHHgNzqv8PXLgrmvb2hDmU6NZ71AUuCYNJSNAnEtbXw6WHsxvSstP+85p2+yljWAnS1vTnk5pW6tXbTh+e788ge85jsQfqjX0qG5ICf6JaVsM1/q7rXZL2wCBi4QwvJ3h5QYIXkPERfKEwbyav3T8PA2H8Dyx3NOTq+XJ1fzdM3cs2wgYASNgBIyAETACRsAIGAEjYASMgBEwAkbACBiBqRHwHvBTh+9lxl8tT67m78sS6XWKHMLXYT2zpqvlydX8nTk3C9sdwgIYk38hcLU8uZq/v4I99YVumsavuuGR/iacPy0Iv103nR/98iv5U+J2tTzp+Dv1eL+i8X46XTHq632+Wp5czd/1GXH4Hg7h4UN0CAOvlidX8/cQSbatEQ7htnieVdrV8uRq/p41b+2XETACRsAIGAEjYASMgBEwAkbACBiBVyPw/OYtYSvHVztgfS9B4Pk86ZgZzkXscHZubZuHu/rb8cK3NkPg+RBum1KbOWZBmyLwfJ50zOFe4YGHnwqObKXbz0Ps4stt5YOifLmrv1mdKdsj8HwI+ym1vcUi8Y2qxYp/zaPZ88+yp1vP50nnJKAmbuFwSH4aXbnSFEJmfIvr0kZAzt9YlbK6Jz1TDSnFByzpYZXB41cCP+kVfzhzAPKpjr8K0Kylnfq0r/RWMR6xh/L79jRVrJLPukBFwI1nNVDF17IQik1wgOTxPNESw8PPaHaIV/76n/nDvnpYH/yFtM9lQQNQaHwZFzWep14Qq05j3N+OEN96JwLjIcQ44bBhSUKygq7T/ubp6xiizH5NwYq/0svRHuADP8zTJ7/aqXpDd17SyGVZ6CzrbJZf2UOBobFWfmW/yoENULQVDpSGc8uCF/lS7dHy1MFHu6hAnDGkQcRZMJ/LQu94xPX3sjCsX7c2ROERoscwqoqqPT4uKgmmvxmB8RBWL0RCXjafjXqOZOBv+q/8ld5qqCg/Si1UjOhVYzCutKjhbiW/skdlanut/Mp+LR8azcrOSo7altsqOd9VispX2zr4aBcVBYj0B8ucpVKyljZ97vJISda7ZmaqOm2P+6u93D4QAuMhrPIv0DWBdBnChUbgVyzW8jdFccnDBspTk1m15zbXjDQe45OS0WD5W6tilfxKuJZvDuOOnZWc7L5SHssTFiCIqlQ36axZQOnvTcTa0qZma2aqa822dmwymHh0BMZDqLMA9SrkJRNIj0PWWVjgp6iKv9JbzQIq/kovDagaqB1cjlXyK3sqsaQPyu/YjyqAd08UW9nZkcO+uTGeJypf497BR7tQtRIB0cftNSJqHIsmK6DyY92KRWh4DjGOVNRsjPvb7G7i+xEYD2H1zktTSt9oNE9f7+d38xT6Si905Uyt+IOdfegxisCDccXFTiW/sqep6AH5Hfv5cp3zR74TpNm81ZHTNBXE8TxhSQVQOuHlraCoaZI+6iBquVfaqEv7UhcfuqR0GuP+doT41jsRWBVCZBgeg3h45lLFBOLp36DwjUkzj5G1lIy+zNSmXu3CMgooA/8DC1IuFWFSKKBN+R17coAfkF/hBuF4LRUUNe3sywkSeDmeJ4w7ujCIHXwqk/j3Uy607y5IES9VSheYmaR0GuP+doT41jsRuHgIMRLyv1uFJEsGZSv5L5NztTy5mr8vS6TXKXIIX4f1zJqulidX83fm3LTtRsAIGAEjYASMgBEwAkbACBgBI2AEjIARMAJGwAjsioD3gN8V3tMIv1qeXM3f0yTqP0ccwn9YuFUjcLU8uZq/deSnveMQThu6lxp+tTy5mr8vTaZdlfE7b35Tyl8X6G/U+RMCnx7PD9wvhc/V8qTj767j0cK3R8BPp+0xPaPEq+XJ1fw9Yc46hCcM6g4uXS1PrubvDinzbpEO4bsjMIf+q+XJ1fydIwttpREwAkbACBgBI2AEjIARMAJGwAgYASOwFgFsZMgtYdd2fzE/PgR5sdKd1OmHPjupsFgj8CIEsGcp95h+kdaumllKG3YV58du8ImfvAV65XHFX9ErOVvRz1Spt8LEciZDAGc7YoPpQ5W2t+BYbWDdMSZv86/HZea7WVTFX9GzhD0oqn0P+ZZpBF6EwPioBicnFLpmxMFFerBm3ocepwF0vNIPwZUt6L07IdJjB7inPgTyrADS6Q5/lTFS6DG1VCPDGRFNhkF+jciInFX+Bhyai1A1INjsSyMwDQLjeYzBj5HP0hCOcULtwK+ycFQKz/EOR8lVAOXBrHrD4VJNIeqR1l/YBkqYm2iXpsxADGfQ4Xh5/RKKh8uFjrwEQ7j8uB1Tv0pOKKkj/oapunaBPdk72umGEZgGgfFR3eTMYxhsPCaSJy0NbjbfLG06k8rzwYC1Th71li4SQ2VpuqZ9Q5tnX5J+12xyolHxV/TQXS/X+qs4qBy2GTtS3DAC8yEwPqqbnNVQ5B8oME4wZcsThIxXJZCcd0sb5lBY3urqlUtONmhP0zVqzI1c2kKtzBU/CKn4K3roHi65Jh3x966zLm0BXl9OicDdRKdXTc48hsEG+p/bmbifyxIWgJSZG5uUNoilDbjszFaarmXbSGku2VRI9oJ92aj4Kzo7Vo1Bfzs4QHLTu0qp6UbgoAjoQOqbWHHqUOG7NrwDwmsjzCm4aVJfSy4KQW9/1vbAqezhdWHfPNzNRuK0dvqomCgUKlzLvfJXdO3L9gP+3n3XFgCnLjeMwAQIIL+5NPteFg7LyvpOxuM5H1766MP/77LoWqlSwQPGlSHovVva9C+tm5/6TsO0GJHIv7cGZ4Ez2dio+Cs6O7LBpShUDPqr0Q9x18JKLW4YASNwFQSw+gslbHbnUVJn98L2GwEj8CwCZ6oFzW/cngXI/Y2AETACRsAIGAEjYASMgBEwAkbACBgBI2AEjIARMAJGwAgYASNgBIyAETACRsAIGAEjYASMgBEwAkbACBgBI2AEjIARMAJGwAgYASNgBIyAETACRsAIGAEjYASMgBEwAkbACBgBI2AEjIARMAJGwAhsgYBuCclTCLYQbBknRIDHAz3sW5VvFf0xRdhg+Tr5/HxcHsN5gl7YsvE6qTBBSA5pou7J/IyBVb5V9LW6rlbatorLWpwn4H8+pcIe2TwCVTcWhxbAgeQLG2rnbcchtkIwRzSc85SfZrobu+6+q/S83WNfju7urf6q2UE+9xCvcNO+2h6UT9eUX+Gq7FFduT14lmPuGChVvlX00B2X6lqT4TrEreLyOsRwmB42icVJet+3833zMXQc0jpUWF9gMef8eWf9kFIPIBVOIeCZpJp/LG2oa+ABkSc9c8zD5v6Rz5Cj8VCXgR4QIw/tUb28m4HFQRCATme1lBPOo1E6xYYjlpVe4aY82q7kgyfbT/4QdNJV+GNtPcOBJRUHeOPobg0KVIR8o95Mb+YzT6VggWa+Mcn1DGzIR2XHU4qhBA4UqPbTKm007QEDcVB/g3zoRWaq2K/bqXJr5aiE3AY4mX4ICksAUPu4HcuCs/VC5JipbOCgT7rBI10QG51o8Fh1xhsnP33fju+jhH4jDFEyB3tgNo0BGysUSypPsyeFAkND9YaMQbroVCWUmGAGRmOorSCiwmre0y+MRg4t0oOdFV3tD12al5UcMFelLdS1gENT0SARmUn3mULqF3hUYC5huJvpH7dnOe6qzL4LzCgq1b5qD8a/PmXpC/tqQ/GnsxwvoCjaKj+XPErmcOZID6evVXIoITeOXtpQgzgpY+6GULFUhYcSHA4ZE0pAs7ShI55mebRnHJFMWMppyIGv/puTkuZxjsao6NMsKw3hJzg8v5musS9TEwarqc3ShidBUw6d0sFA+dSIRkWvcAvdeVnJAYMiQL0IIiWQrmaHu+OXmofsxYCSEszODOCs6LjbeUpRERqhtGWxtIcNdMyvRILk5vgKM3eoQ8cgn9I4opHDHGKK54gcCpyswRpEIJi7GrwQD86ZOctQZq6wFIsce96ltFAFyKCNj59zmllqNbQMlRJZNfB8hi+YtcH9u3ohjcJhj073NF1Yj/QRShcILykdOfqoJ9TBNcqh3uaJixk3dgyNSj7Ysv2YeucJeN+eoLRz2bQn5FvnYRYkN/OQq8XwDrSpGgKDAeFS7QlCwlAK5uGSI4JBh0CFlK9BgnwK1HTVVAxC7sqhwMkandLGBwV5gm/ADk+DkDG5S2CgqPFZG7toqdIcIh2Wa1po5mEQoqDowkHlhzYe5qz+uKvvXLSaINUUHJWWS0NfDvoG+5uzoSrFVXsVBeXpy8n2q79qWF+Oauy39bFBzuxIUJcZ0DfT9aXBEWZtwcfmbIs8If+VziUCVyq428SzLyeIneOSNYjjVnMXI0qfM51TyvncxjOHsyoAkVMKZYWRu4vXH3knUg11aOEJzTrroSK+sKd3d1WDk883yNfSqZnBMQZjdLQz26gxpF1TDt+zoBflU0ifXuEWuvOykg8GTY+gN/jbl0N1dxvIE8LIKbYO0fyIyvkGRZke8lbDqiqCnZqBuKXMak/AQUdTkIlns3qqfSsclCcIxOj+koHDXFIt6NWRE8TyEhNAXh6r0S9tmP5okeJUGV6xXnDGhCk9xdLbkFK6CiNPv6GrhjDB1jjxdSnrEXMX8vXFUFiAdAwIH2fkN3R84GuKwAaYFxYCGEJ9OewS/CVd7VeiziIr3CpngxwO9Q494N/0V7OoUl3RMaphgMoB5s2XUyHfKDnTmScoOgopb4UU4rOTYtFo2qP5gAFFuEJ3DCKdxev4YlUiDqjyQX6QGfIWdwOeI3KCWFzCkuatCYh94CoHcmmrOE03AhdEIDwneDkXFJjozGXz/63VvzGvcsClbRVcZjYCMyLQX1wf1COsYnQdtMpQl7ZVcJnZCBgBI2AEjIARMAJGwAgYASNgBIyAETACRuBUCPCbiVN5dT1nHMfrxfx/HjvuZdwNTQnNVDccx6nCtZmxjnsJpaEpoZnqhuM4Vbg2M9Zxj1Dqp8/8yhlM+hW7fqJt+gHxcRz5q4lL5Wcn7nGoX/baVf8coXcczxHHtV447iVihqaEZqobjuNU4drMWMe9hNLQlNBMdcNxnCpcmxnruG8GpQUZASNgBIyAETACRsAIGAEjYASMgBHYBIEH9obcRC92++PWqR2Z1c5x+vfvETkdFSe4tV8cjfOR02O/uB/Z6yHb3gXN86UN7uXdU4fcPh3T3nE0zsdMmb3jfkyvh6wahIbbZFMoD1UgZadGNWuDOg854LB3HI3zTun9pNjBuD+pZcrug9BgkqUecrtKPTaBRJ5jwm/EuWbUBY4KHJGj8tG3OeS4B3zmV41oo3TSTn7d3rQHe22CGUe36KEwq/RmS56h7BdHWJVx1kdOeM69EYdnMJyx72DcZ3TtWZvHodGTe3Q33eoUbvx+C0dd5BKTa2VHDrvz7He6nYccxhUq6chO6GonpMHmpj0w+/N2KCqKGo96WquXLmzS2C+OMC/jXJW29+KwCZgTCRmP+0RObWPqODRaJjiegxG6btXUD2zVyUBkq+TkAZYpWoJxl2KbjWBnc9932sOaznkKoVirt2nMw8T94giTMs6KG9HgIbba62Gn3PEuAuNxvyvqbAyroEE253rB1Zz+nF5TP6OWZ204rJNn/HBhqHLyAMsUSmCDa+FsBhfOvKWlLfvVKW1Ux0ZfLzVu0tgvjjCviTNPn9PSRvfZeCUOm4A5kZBVcZ/Irw1MXQUNJi+ax+HAds5ucskItubSVp3mraUt98pDTmdPQWnzUuXreZFNezqlba3epjEPE/eLI0zKOCtuGvf34vAwgJN2XBX3SX180OxV0KCy6ItzlDCcCIv37s3ZVjYuFykeZ5vlUKaWG8jMQw7vejihuDtl0CGqpa1pT6e0rdWbMXmGsl8cK5xZwuA4Y/ReHJ7BcMa+q+I+o4OP27wWmnwqNetdOIU7lIxgYi5tfTlY3XD8UFoubdVp2+wSGsFOLkib9nRK21q9wYwnL/eLIwzLOBMfqNbQoLohZPwT0JMOunsTgbVxbwo5J/Ei0PC9T2icJqgXieNp4rWVI457iaShKaGZ6objOFW4NjPWcd8MSgsyAkbACBgBI2AEjIARMAJGwAgYASNgBIyAETACRqCNgPdWb+MyG9VxnC1i29jruJc4GpoSmqluOI5ThWszYx33EkpDU0Iz1Q3HcapwbWas4x6h1E3T+NU4mPQ34fpzd9MPiI/jyF9BXCo/O3GPQ/2y16765wi943iOOK71wnEvETM0JTRT3XAcpwrXZsY67iWUhqaEZqobjuNU4drMWMd9MygtyAgYASNgBIyAETACRsAIGAEjYASMwCYI7Lcpiv59Wre6reiPuYMNEVX+Y3Jm77VfHJdlCecWPoZV2PLzMSEH7PXefN417gdEe4VJe0OTd2eFcRV9hek3Vpc2ILZrHLlXeIgOPyUb2Uq3X9qQD9z2PSg6/uW78nnXuB8f9p6Fe0NThbyiN23tj4pml6sRN4ljhXOTHg5v5KezFfJNIWTG3MeljYAMNjaJ+6CuydhWQaN73msq40AjHJsQ1oZVCcv0sOqBHM4LuPE3s18XAgH0pj0YWhSo9ofuuGzag1vEQWcrQT7s51kKVPG1LHRhXA67V43xOGqJ4eFkhCXgrCDjFnFjXxwKATr8hbTPZUEDUCg+ihu6o1ASmcpN0GktACTzCJ60X8+yUHvUTj3hqJMPWLMrM01qNmin/tpHoW72ahLH497sfmbiODSIB5OPJUxXKyHVOiFvlramzP65f1iQaoQqezAyYT+00xftzraWABrG8QCKzlxUfh4qKhZtYDUuhxKajfE4ql9anjo4axfVjoeZgoBwfC4LveMR1N/LQli+bm2IQsnQs8RURW5rX9Q48FAjYvT3p6fGReM+wk+DkclMA80x6Mn5/KM//hd6mXuUCb6cz7H/7+vxuP/ud4GrcWhyOJuVKwyDKuQVHZDruZadIZdPoc9iaQ8bUMGTq6ogNyehGIE4nJDuQ0KQT7FaPhRtxRNm9+VQYLOhkpsMJKqdalsHZ+1COYACcw1OhThLpWQtbTqeOcdh+bgbEahWYxS3QTypZZBf/WU75CczIdQp8mtD9SodbZe2jMmDlMeGBJXlSGjmdUKea1B1enxnyOXS1rEnGMYUpy+5wTUIhy6MwUSA/yKhg3xKC8OP2c/ubPTlUGCz8VgcWYAgs3KhSWfNAkqYJa0tbWr2YERYE5ldNJ5IotHEk1oCM8U2nYUKLoR1IYlbzXzGrfBvR37O59A3XyqA+e6lKePQNJ82OaIhcpkBcGe6Hp8cnopBpgYs1LIsln3ZQHemuEprtiGTM7UmDv36iyqAd09U8YAc9s2N8TgqDoM4axeqViJhHyxtjJq+YEKtIc5UpA0qAhGXaA/iybgP8lN7Jz9ZZPncYq/cqPSCk8jkjk3KeNyb3c9MHIemekegoQKP4hVykbcyvXlaO/hVBSWgkVNBmdUeHYp33+x8yMt+mMrFVIVDkK928uW6pv4DclRmaI/HkfjAAJ2Q8lYQ3nRNhzpx7pc26tK+1MWiQ0qzwb6cU4NtEE9qGeSnDZ38XFXaKr1QlPOZBjQb43Fvdj8zcRU0iAqernxNi4UkXu7yvQkhyyUMtzIdQcXLZrQ5EniL6UX5zVTAZCS8LAvjkylOUdrgsGlOJQIOzYWPSuNrqUB8QE6QwMvxOBJMdCHIXA1llwN0VMo5F+PeL21UrUpVGp8fJOYGQ4MI6u/DR/DUuI/w0wAaT73qRc5ndsyNoFcZmvmsDKE9HvfQ8fyXF4cGwzj/O13gTxbHHBFQQlxYSQP97ZeD9j9v58ni/jwg/yQYmn9YzNy6Thx1Uc/F6cyhe8r268T9KZjc2QgcHwEuDPOfKY9vvC00AkbACBgBI2AEjIARMAJGwAgYASNgBE6OgP7t/MtXZQwAAANXSURBVOSunto9x/HU4S2dc9wNTYnAOW44xc8Rx7VeOO4lYoamhGaqG47jVOHazFjHPULJ78j5bSF/XaC/Ada/r5sOEA+Fg+PInwQcKi5hr4fNx1En7nGoX/baVf8coXcczxHHtV447iVihqaEZqobjuNU4drMWMe9hNLQlNBMdcNxnCpcmxnruG8GpQUZASNgBIyAETACRsAIGAEjYASMgBE4JQLY10E3rjmym/jg4MgWjtumHyiM9zKnETgiAtjJb2Rr05dZP0tpw66q/KgK+PDTqkCv0Kv4K3olZyv6mSr1VphYzmQI4OxIbGR8qNL2FhyrDbI7xuRjBPQ4znw3i6r4K3qWsAdFte8h3zKNwIsQGB/V4OSEQteM+SwC3YEenmBL+45X+oG1sgW9dydE3Dtfz/SFQO5Jz7386Q5/lTFS6Jsb2CuSTQZ1KpyApfxr5azyN+DQXISqAcFmXxqBaRAYz2MMfox8loZw5DBqB35lglPXeNZ3OKquAkgHOXhUL5aB/eqjHmn9hW2ghLmJdqkMU3o4444HGpHn7iEgYMj8FZ2cuaHGj/gbpuraBcKzd1mpKUbg6AjowOjb2uTMYxhsPLsXx0otyzK4iXuztGkty/PBYHY4yIp3dZEYKkjTNXbMDZ4uzFt3zSYnGhV/RQ/d9XKtv4qDymGbsSPFDSMwHwLjo7rJWQ1F/oEC4wRTtjxByHhVAsl5t7RhDoXlra5eueRkg/Y0XaPG3MilLdTKXPGDkIq/oofu4ZJr0hF/7zrr0hbg9eWUCNxNdHrV5MxjGGyg/7kdVPx5m7JxZxEKbDY2KW2QTBtw2ZmtNF1rmgdic8mmQrIXWVrFX9GzhEAZ9LeDQ8e7oMuXRuDoCOhA6ttacepQ4bs2vCbHD9wwp3hNaXvg1PfwurAPAu42K5e+v1NMFAoVXvFXdO3L9gP+3n3XVgWaSt0wAsdFAPnNpRn+mNg3t5Px+S+kPFIeMsfPi8xVI+jtL0i5NINr+FMG/VKv9S8hUNrswr6hEYoX7vLvrbowrEqbbukV+Cs5wQZdejeNr/wNdBWrhVXpbhsBI3AJBLD6CyVpds9RUmf3wvYbASPwLAJnqgXNb9yeBcj9jYARMAJGwAgYASNgBIyAETACROA/muQk2En887wAAAAASUVORK5CYII=
建表语句：
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZcAAABmCAIAAACIvUtSAAAbW0lEQVR4Ae2dDXIkq66Ee12zoFnPrGY2M4s5N8L5/L10Ciiq/9y2dePGGUolhEggET/Vvlz8f/9dLvz/r734/S7/d7kozVte/Xe5/HnPgjD0/3vP/t/lgoWLCV3/1+Xy771cN65C/tirf5fLr/eiZ/+GvtTkD1lU+syfy1uJv9F+c0+PuIr/aEW58nOhT8ZONAKNQCPwOQj8fmO3zym7S20EGoFG4DoEPBL89zHMvM5g52oEGoFG4KkIsIKOlfJTnejCGoFG4AkI+D6Xxy9PKLqLEAK/yu7eFcg8uh2vsH91vf6+AXIFCJ3lRyOgDtcs9lmdQGcLt5f+6HYc2te2o5+xUJGz9ZJ9P2XCVCcagQMEhr3zIM/H15zx6USVPs0Ba6zsXF6PO/993I/3QICM/94c4FEJzmQ/evd/Tws70ohydQZKESpRmnGWSnEo7/hDrmFiVsRQWcLb23Fh/PJ27vyfnT7/eWsmnfnS4msL67f/7FR9rdlvvwwCmuUUYP9+26JWH/pbGvvP+wa2s0lcd2AMq/M5CtH7/xT7rlzTMYX+so7OUJQOLIO8WlOtfbSg8/e9mkgWdtCpiWpHlzkEkcekbt/HmMvd/kzuOodptbgT4iZHRDuqIFVWBO1V8xsnhD+L/lNZjIrcpdbaysRmJ74JAmrX32+c4vxV25tuREJ9DiA4p1M39bBi2DvVxSEd7AwTQ1KQpvuDD/Wel5v9+3ZbbWizCt2+G1mnq53LGz9qqmBIu58iCNhkVu5MvvZn+PYKU5XFnHnVpiorAijYzWcgz6tc1b7kV7haqzxslKrWki+GABedCLWIwryHeWxVp9xKUpgFjlnvVFBwyGV1SYhl+reYl9GCHE0lRLL4HG9rR5/ZiYzxWO3Myp0FRLNyZ/JwYOfxClPRjvHopOz9Z+bMEKVhjHyFq7VQ+nZ91ZIvjAB0U1nMwzEuuKuqLAqIKVyZpZPjUrs7b7EGAfGKxJrFRASxvHV28MDQF7N1pNVxNbODb8NEtTMrl/EpiIAUedi/zp8wosdZEUNlCaMdo92dxRbGfT1LfYf28WRhDZ3DRLPYIURfUmHBYpf3jVV0oobq0Aqjaud24iDwqTy1GYv9/bgZ756of7szejvr92zewX1urbLPzI7nqulqZ1au23dScLnbn8ldZzN9halo6Hh0FqszhLzyVX9FqRpUritcrSDU4qpOS74eAjBUjcX4tNADsV9vO0qqpzqc7+PAaPUkrvbOU/tiyv7XNvUhRPp39QffaBhtS/Hoo07C2tGx77kO02FnUa7b930ll3txM7nrbKZnRLPIXtvRjbj/s30xwmrF4M+MxXySWNSxX30xBNYspnDMoypWfwpkfD9L/VvXHTALHNH7fXmFzjoxK9pHtbqpyMtXXv+9h3La1/eCgm7iUTTnphwNtxPpsLMoN4w7O/srRrsLqVeUvvkouGTQm3KRPdpRmqps3TAVkck+uFEoX9FTtRqzu4Wws3By8co5d6HWr74VAs4R+xWrLLaftzU/EYGgSB4/0aX7Fi0Wdt68r/229nII+NHkKeeaxU7B1cpPRkC7sU8utIt7NgJq5jj123eiWWwfq9ZsBBqBRmCKgJYPdY+fgws2ocKEMoYwHq9ba4cRPS78HOo/VHjHeuHnLbFPfFiGzU40Aj8FAZ0J1Npqj/lFWEy72ux/V2+fKbkvi9V9KN+wjyMFkV2lrVtI8JnQdVmNwAsh8ORY7IVqfo/f8PHq1DPB3+/XZSIC9U3Ymsvfuv2a5iaHXv33rsHZqCvEJb6dY1DPriNsCvKon3Jns8JM/u5v//vyCFxx0+JedfKOGzaJBRQvxNt49F4Y9yoIN9hYrLfGuaAXZtePdcOROxx+E4VyuRBH1Tz8xE8Pf1Qv9DnOu8K+iGNRI2crx3OY0RUWNsVEVFNsIoNiGbFnDQOp6cI4N2/CPjiTt1kMKL5zQkMoOtPTKlzHiX8esLOEYVAFQ6le6uVEELU4sp+tcmRktMy+stao1gB2dpOfhA8+LCnCw6Wz9vX1+5oaoiCgULm4JHlMFShHQnfoKFf4+AcD7Ip6xk3jYiu3Bv7URWZncgoNfeSd+HoIiC+ez2VrWtEoWqOpXugfNkjf4wu343LYbV3E8K0HcbOQ1sfkbLS4P15Q6NcKBj2FvpsKfvdXfN8m4bo5pOMVD1P+qI/J8UpswqM0K0s6Ym6tpof2OxarQH0rCWsTBQVMklSSpUrMvSg8IhHDJrq1s8+sdM35dUte1fT/ql5e4pAaZgWF3H3z2ErkQrngHAMYa5tyd9Wb8tC+/JnNT8GhXql6g18+77PY5f2XpkQulWKiuYOXgWiYEC0qksV+LaJjsSF631P4IrFYdOsYVEPoxQK+DpVajE/Pq1d1b8t1dtKKceLbTF/meGQxY6uZn6EPi521v6CGYdFerjM+gHilENYE9CGH9ejO376iVKFuv1msNsSPkLzavhgdndhw3QyMuiCy2X4TgwdeWNtfvBUP+rfxGkUKfOT/Yaw085N6yQG85Wxu0z71jYoEXLz1VfYhzZGrJmAxTUV6FC3ea3dfhbr9oGyfqAJPHJ7JpaAzKJQ78YoIzDZ0nuZrne0hL41bBsPMJe+F8RseIggt7mLRF5oz44fyakc10jpXaRGZ+xlmw0+9DX1Y7Ar7sfmFfZa9MKNesWKFgnHYOQ7hMOENpwpKDf+jUL3dDPR8CenrVoyoXXyfwSsbZ8H+KqrcLDZs3BZeg4D3M09fY+stT3DE1Xa+SkYFLDFEzzovdjub60vrezT3pSvSzn83BPYDim9W81toyOOXbwbLojqEwAudftUIPBUBDeNYXT7Vgy6sEWgEviICWs5wsbNWQQpVfrtEuzB+d8S/GXA5FwsWft7uz76FR6x5Oxbbx781G4FEQHv2KX1/fiaLqUyVGCz2o74G1wY5m4x+oUxkV5eQt5Dge1P3v43AN0Vgk8XuGJ7MWOx1AL5jZYdnlHHMR8V907DetPC3ZBkm4Ecd1zJhuNyPKUPux4v1F9vlvEfNHIkOcfMAnIKiiKiF++ZYhf11udXPKKUf74DA5960YM73k3gOzr33o0kXpAdzM8P11e9RrkjdyGL16Oorfg3OCHR8fJRqPe5v94el2/EgzuVueSbXfTfREFRY3aAuCztxm8xLr2l1Hkqc2Z/JMbj2B7VO3ISAGMQXFDeZ287sty69l8sf9Z6Y+YcdYvZ1tBwZjkO2wOij217/v2I4Q2+e+aNRIfL14wXV10lZZbi+OFc6Z+0vhq6K8GO4CIqHXL95pSvwIawLOYDO5PJ/8bfcgYsEYGKcxKbzYkkuYOtxaJ92n/k/k+NSJ+6GgHjkmVzmreuDh+4O11BJz4LQE7WPPo7F/HPCWUjr/syc9/p6XULfuQa1HftigUXLCiKN/ApXuKFIeefeWWTE1ZBTl5mcHVXvJM+JxVSikJmx1Ux+WC8UOnECgViU1Y7I0uyWCGXToZjkvYMqQPD/4s+so3vVol51WMrDcGDTbVdznz22EmvgP/7MnN+UO4sN6zuzc8hiUpCfXilmEfBX9Z2+HZBIhz/OYoDjO1MIlaBQnyGc8cP+IZvIPdwIb+ujDLLXMbM/k2Mw/ETeifsj8ORYLEjEB4/31KjnsEN42F/76ONYDHb4ul+DA6/j5iAP0XNlLNSE2/HjhZCTcSaPjXmIL/QP2UQFbTrvS8j+2pw2et3EZ+2LwT7EgMJotk/kI8HR5CxJdoh9pDMch7Mow83upL/01+ACASjYS/K9yOGMEvQxAwq1X5eL5khpIo+MQ3nMEL6QdD7yw5ahHcryXAiHCWhRUyyPbmGn3LU/4uihAy3cRcDD9d08d9KDvLRWopf4GWUcO4qStOJgowchdpzIHspiwxsAM38WvVnErXrNYg1WlFfYH04ADE6mARqWFasjqbfOcegPE75CdDsuV/sq+xAfTn4pwklEB0TxQX7Y96J97YzBWaJ2SDRPlbv2p1kMVDvRCBwgIM6KIX2Qp7z2kKq8bME1CHg0d03+ztMI/DQEbqGhepX/p6H3iPoSYj/CeNtsBBqBRqARaATeEdByhv3jd/HD//2scocVG+77DDX3hbfEVrNSOuaaIdPyn46A9vKfj8JnlVtrel8WG+5zaZOlzhaz3fq1vFahJY1AI/CjEbgvi8UdCB0dxiUVwe2nip5rJq+51s3mZ3B++9flfgwacs5kVUocOPrVCilwdDjEMy6XqawoIqrjvvk1sbC/Lrf6GaX04wMR+KybFooaFAvoTpD+vKCqys0DRsVaX6fvGgDc+T6FWj0q4oyfGyFx7UO9nHDGy8V/X52FPseFV9ifXR8ZjiUfjZ5xJgc3V0BYE64mNKTjcs81k/dX345Sp88hoCHH9atzma/V1nD6/f73CnUxUj7IH5EC8cJCP+IL5syzrsXows7Zr6/lP8s62E1xgeS+YXfW/vrSU9RCBQGFHlUiFeTiK65K329mYaEmokSaI+RknMlVr/7qG6A6cRoBzaJP4zJiHz7K4+9XMwwYXczS/imy9BmWVHgxSNAZJvBEpQyh8IE9K8j994JCf3jEvmOfL5/cOOkoxYMv6UhhJseOQ+3Cmo4SqULIyTiTs4MZzBv6kG/Isa8EboS8PvbfGK+YvK6EtY+CAlY0eMzSJuZkFO6YWLBY7Juok830d0bjpts+eFjJKq9DB26zUbQpdxY7Zf8Ui3mlmBU2YzGn9QWGUV/ow9vRd6ZcHtsIzBw+E4T9R7AYn4v0vtiiob/Aq9eMxQBuxmJ3jMVgh/h2j+89pXDIYj4C8b/uWMFiZ+2HG15ELSUkTvrODi7HIHyEZJhwO/6pU8jJO5PHxjzEF/oPYjF5rlEgV8+WG/rUtxPPQOCz9sXUTZnwWVEO95VmLObDxmfU64BTKV/0b32rynUssbdYsYIphsxbTQ1RRa2/+mYztALV30tWTO4m+dwzSt98gcUgIy09tLhbsBixyS1nlABaT/oVp+iAUmmFY4xe8pIQEeO/5KFPLHaF/eCjQCzKFT4SEkjKJVayIZdBOI56DROyXO27vL/6bhYbdp4W/mgEtJSu7HMXUHxhdReDbYRpuKFoBBqBDwg8gm78jtuHwvrhBgQIvW+w0VkbgUagEWgEGoFG4NEIRGylZeNwz1i7abM7MXHBYuh27NMNdTaFQz87pttEr9UagW+CwGyfi7ugUc+XYjHdRKunAUHKUYV+bAS+DAJ+VuW3SV3uu9QuZz73Qy7dgfIsOrOLUeR2UNbpoWPnZ6MuJ+0xi1+hcvt8UXyFfRU0vOuAD2cTT47FFu75PY+FWr9qBK5H4Ak3LYIF4BrkGnLc21ZlglxEGVpAcauLakviF8H9tmfY91umOydH+BkDEjluKHHWvr6v4jJnWKuPfjs03ir2EaUeGnT/nZ393gazTjSHdJgbwo149ILiVT82AvdBQOFDkMh9TL9Z8U6sdZCMu9xHvt7GsNHIlJP6tQkfQkhcOLMvUtNmUxDfsNayExTmLBm5ztrnvlvYWT86ktKc/a31mR3wCajVHzRhUOtaHNln9pEHRSLvRCNwZwQ0jT+Cy+ju2uKBaJAPt3hiaIlu9F8FCNhh50j0AS4L+xqom4s4rWpraIN9SiRxyr5Y7Czya1oJKHDME/K/3gBwWNyOy2E3NzhL83nGTKHljcAuAiw3tDqDBcj/oK/Bff/IC0XOsgVP6sAWiehi/Z/LRR+7SN8XxT7SDu2ztvVya5oFWhAN9mPPThY8Mqo2QxKUHW+Hj8FiohuOLJ19htkVS9YPFST3qhGueomV+2alnFp7Loz0q0bgGIEnxGLhhGIBjbcgiBmLMZCcxXyfyAnl0L5Tavjmj27HLz1I7pqePrWMOqWsUoBCj9exmL57Dzb3mcBrxGdPO5uJnvGK2nn2TjcCxwg8c1/MvYEFNAKdIGYsRnZYLH5/wrerDu2fYjF+1gY/sY9Xnjg1dIOS3M4sXbOwt0hMPcsrOf5H2Kj+QDWJ7ziFOBWIeYus/em3jcCVCPhy7EoTR9kYLaHoco1JjZxYzohrYlsKFuN3pTEOfczsSxM1Ms4SbscJN/yMiGbfvspdREBDxyqLQV5imUCsGvF6xdJSRKYKxno/NKvZkJzaQYu8/dgINAJfCQHx42Z4uF+xoFoe9y2EpnNfvKqP2qao8pY0Ao3At0XgxYf9qcCKG8vftrW6Yo1AI/CFEBC9xuryC/nfrjYCHxDoOfYDHP3QCBwhwJaln6EfZcr3p9bymbmfKwIvvvCpDrekEfhEBGZHNxpHojY/Cx66umYxP3caZm/hAIH9LRJ2lJXgahhfUMu6n6nxXaQ3cNhhI3xmJ/Qpd1CZN1HoY3+mf1bu9n1pFvJDs6FP73e5YxLyOEutZ44xWmiXkMvPuKynsqKIqJEHJm7T0xqTnnHoJ1Xzxgr7QI2yEuoPV/jvXkXaq+CvhnIfQTsn2kMjlKKKcD8G+Y9I3HLTYg0r8M3U1Jl8ECqLJijaw//obL1Hxl3zamdWLo4NE/UavewwbTJgZnI5qUtYDKG4NuXBrPs5m7TdVdef2Znpu5y/8sntfL11+3J7KA9TO+OQO3dg6I3r5QaLMavRyo6nlJmlAkM6ktsP52myKq8St8PHVXQPuFLlVpak7uT1zxtUU1nTXUhaR+XqlfcrZRcnUlm5LWdqFb6h5Opbr5sd11vd4VOcRaNqzj8MjIcsw4XP/VHnnnh6aJ8quHvqIuo3LvdRJGxlHyN6RA25G3GXIo3+zM5a398efkW/j+dmZ1ioeb0EBa4e+ukdAGDJroTbj1e3s9i6iFnRCjA9KOPipHqO7kWKoH1d4heVFXvqy4qfy2JqAHE8E1pt5irxyaS+RTJrQk0yvBWL+bDHgieGLOPjf70Ckn0mTCW81kP73jm4uY7nck9yeTIMGUKf8ezOeEFea08v7Ayzhz6m6P1BGaG/xhNrVAfJMOFL3VBwHJSWwqGfGvlgrkedQSH02C3K1WP4v+gnjk8MAX/lpczkYjE/LuPrLizTId2IdzPiMnqmF/3d0hH0EgRRTzYUvO15WxMAXV+5xHun75gEbcWj4mTl9cFJo1JEZPRRR9FeLhmHiaF9d4C+4r2KmbBeqUeNhMpl2CBX16ztEn6iX+0M64tQCRrXNxM8fgn7jqfjEF5RnZDH45rFsO/EuvBTNWIYe1m/LhfFODS944CQLJv+BxvGEAjoMD6U09M07uTSWRYLcACQon9W4opYbLPhh03oSxUtBzRafJJRA0R22p7mYZi5nehtKC/mWOkM7XvnWLPYwv+oCMTh8kqCeE7C9flCe1bfhTy2bBjYYR94Q44/4HbIv1q4UVBYcPvOYms/penRtJv15nD7rjP0f9FP3E4MAX/lRQzlLsTPTRajnwQ4i0nC/fmGaTXYrB8sKuzNcIUaw0NNyKPW/IQMUcqQZVR62ImMCw/91dD+Pos5rRBOyj7+aLOD+iIPfffK0+gv7Az1Xbj4it5HJoNqwYYy67m8oEirjfyvrw8bWmo6fwhypPokpEwb6YebVC6j/V7+e/tq4Lh7zExRa1x1ue/lyRTnLeoJskyH9IWn58Um8ysShZ88ftuER6SnKulbkuuMHslrh1L6DOM6ejV4tGvAeiHs0HtmdkJ/FgLgfOi7fUYIK8c6KrwPaUjLfx+lFIFx2UFOZfGqJlD2bh12Amf3XwYXX9ETMcl/HPByo+hTu+NsXMgg06cPdVhs4afri61UTd85cTzD/+gPmyzMD3so6okVpdyIetWuAqREUvjJtIFlZzHse/9xa9HQ8gSFTnxAQB3lg6gfGoFG4MUQ4GDkxfx6AXfqPPwCTrULjUAjkAj4+iDf9XMj0Ag0Ao1AI/AdEPAtHt9nmcmfVmf2lTZL/E5bBL1W2Gz0VrsPAmzEDncr71PGI63MzqRm8kf68sH2PotJM/A/2y5Dfb+swBb+By8f9vCdSPlhID3GMAcQL3LpY+aPnw3tn+xUzPyU89OHfXVvR+JQuP5M7jo76avt7LNYRf5su8z0f7/9qSq+nYzjs53q36LjXt1ip/OeQECUoZZWF2T68q7M+atMM91xUsuxLtOjTvo5r8WnMIVciR1/buwoXi8VFz7Eo/SjXtKpNxvqvibnNbHc4yZEFMfjUJ8zcs7vFc7M5LI2bC8umsiU7FBN7DsLzOyQSwpUYZYYwn5du6iIoUG/YzXzRGQHet6fHZ+ZfLiK9Iosyu1Xd0MgrrF5b/DGcOpRT9UgdEJRv1enp9XdoJx2s7Uah/54iTX7oSSCBT2uCWVYrxghjF5Ym+9muefpFV+XqFr47y5E5OKmvMpD+ay9JIek3KVTdqipbm/5NTr3zdM1lD7bLpv6w4q4J8y+EjoIV+AmI7V2UWI/3hmBaGYf1f7KWcxHlHcm13cvXf+Qg8JI+KM5342fTZ9l1ejlFOeOSSjPAYqrm9zvjcuomNpJxMAIlLAwlDv+3l4ux4ISp+y4stsPm/4I1yM82y47+osKUq5mIybdkLMu8XodmqUPuLVOPxAB74JsJWhG8lfeMKw1SFR999g7XF1wuWalDCcLbdvduHnn3THqG57w6Dgg9EpJKDXdgf799kkwv+vCDM8iMXa1MRsJVmqxchm6VNHDMVpKiXV7nbLjDQSeUYv6WFnsbLsc6h9yjXs1bJcALX5vy7NH2gdLvOrHhyBwuIJTqR4LzPrHbGix+OIrh0VNDv1R92UdtDA1e+V+VjKquVyftzF6GfmS/7lcfr/9fxh7ooO1YcKhcPwpq+Yaujprr5l8Zn+oHzjosToWkqiO3rrzZ9sl9Ieuhg/1MdplZmQmx+CwdrztxP0RUPOLFGatqA0CwofZfor3wnBUpRwGYnwsNvQH+/IziEwbtFHu8NGZ5bBHzoY01KwihInSmsPZNtZ9rl9vpCaFof/VVaJORQrgv3AJiNzarL1m8qgapmb6sC0RDVlmiSAdqS3aBUjd4Ezf9+lcf5hetMusvjM59oetwNtOPAQBhUjqKGwEQCgaSxEkqyGVhT2FdeOxT3RYB3Xx6o/br0Swz2JsQscybeaYlxs6mnVjw8un4jrCa73CJo/gIPZ3b2cuzeTD9vIzOP+K25seJpVXQzuQF35ShUViOH+wgnbKFmsPDw2G+kKY/3qXrv7g/LBdhvVd4KZXfg+5ltiSxyIgavBfL7ljebMBdq8idpar9yqr7dyOAJ3tdlOvY+H206fXqcsX9sR/b/uO1fDg/45m3dTOctX1O/0KCHynYe/B8itg2z7cDQF1U1add7PbhhqBRqARaAQagUagEWgEGoFGoBFoBBqBRqARaAQagUagEWgEGoFGoBFoBBqBRqARaAQagUagEWgEGoFGoBFoBDYQ+B+qAWND10xGwAAAAABJRU5ErkJggg==
这样的话,理论上这张表的排序规则应该是：utf8mb4_general_ci
但是他会默认改成：utf8mb4_0900_ai_ci
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAjMAAADICAIAAACS+vdmAAAgAElEQVR4Ae2dC3LruA5Eta4sKOvJarKZLCavnrvS0xcgadmxHX/O1NQNBZEgeEgBIkXJ28Z/EIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQKga9t+/75/62cu8Th97a9X0LPq+mYcbt2f804X7vea+uftQs5BCBwvwTeDsGJyHQ/PTSLTLLwev21JnDteof637fti/ubdcdwFgJPSWDoES7S0rWHvUgV11ZyqSacpGed+SL9ta5iSPUi9Q41S1j0fxxi0sfhtomZ94IbpyBwUwK6W/z8uTKVeNu2z237+NeQj4Nw27a3w8WsBbqvw6EzesFEF7zlKvUdmT+a/sw8TM/qlfuT5d8/RkrD5+Hw62Cwpmv91lhqhzVaKM+lJn/+SEu9OR10/uQztN9me8Ez/eNQz0/9//xd6BnWu/3b42mn9BYPLuFF7PnH7nYwrLf3Y7En+33WXhUZ6jeNYo46pQg5hAAErk7g/cdDyek4Jkme1fv+1wnFG+f5+okKcg1fPnFIdI+gGkv8+7fQP0ezeuU+5NBVi9JfEfxU13awUDV+HsLVdljDcbD5p76fA5V1wHAEynrTs5vkdjDAHN4iMKdtM7c40/Nj1+BvIvLpWb3fEbBNI0vlnYTaYkm/83DBTAztyQw93cdJsnI/2p7eL7P2qq6uX/KhqUSm3kFIIHALApoz6TqXg/ZsqXgEe9icgtjEcsFb7SyD5brZ3xOfhvV2t65ZUbHH2TzzkzY1fF17crDZVpgSpTO/zOh5NAmwfOgW9+ixBiWGejJP1puZO64uuYY9aZvSpd5ymNjTnq5HkmzvUL8LJg0LSUAAAn9DwCHELtuRKadNZRHMCyaebWRmTUQcydSw7mLcYGvzdMSnSsI5XW+6KmWWqcUeZ1N73w+zmc+fCdO63pnPWsh1r+1/rT/X3BZNUENc3AnrKVh8ODNpWG9m7r3TJTbDibPtscE9Ueqd9aM7tGvQzNhGJue+quziScNCEhCAwN8QWESm7bDa83Fw3yXMyFY5EU04ukMpRUoGt3b/nMlFst7uodZzJpd9P7Rrz6rU7N585stm+b3aKdeZHnOoaqbHHHpipsd15RwiM/cA0PvrUvZ0s1NS6i2H2d0zexaciUyJmjQE7pfAOjLJYeWE6e3g0NUeeQ0v9H//PNe5xnOmdb22QdFUh+m58vmE7qblpLymt+ghlXUVniikZ8/ii/yO4uk9fQeQShbPUUq2PMwmW176xVEqdw0Ue4YefNYuV9QTQ3t6tpT0UJRKsh9n9szaq1q6fsmHvemhkhaShgAErk5gHZnkNHP24/U0XbT5hEbXvPyd1boBxSOcujdvUW/xKRlHNUUoD6hy3tA9sg3OhJygmmwapd5FfgUzhXntO1DaQcKn7FWlrdTroJh1ZXqox0KRcUCS/WqULbG20l8XtMdVDBPDeof96OBd+mXWXlVX9Cfhokfzs++hlQghAIG/JbDwvwvDemRaZObU6xCQ9+//3icB3Q/dp21YBYHXJbDnMcyQDpFpiAXhYxHI+fdjWY61EHhOAtqYkK/pnNROItNJuMgMAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABB6YALtj1XlweOBBjOkQgMCTEcAjq0Ph8GQDm+ZAAAIPTACPrM6DwwMPYkyHAASeg4B/UckvP/obB/kZUH84oHwu82nkcPBnIF6q3591PNMuxrNc+sNxqIGVuYKIwKGODI4hAAEI/BUBPLLIw+GvRiD1QgACEKgE8MgiAoc6MjiGAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhA4DYE+IKnOMMBDk/zhWK+6PpwXzLF/9wm3lELBCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEDg1Ql8bNvHdRh8b9v7SPPXtumX6r+37W2U4U9k1+PwJ805o9LH6q8zGkgRCEDgYQhczyPPPJ3QvB3iE5HpfgbKY/XX/XDDEghA4PIEdkamnOh4xvO1NOexPN1ODtthnpc0hvPCJZjjJ9fojpfftrTwKftrDwTyQAACj0pgv0dWCz+3zW9ZS/IWfvArFujkXvWGc8pdqq/mffws9PX81+a7k4OmeibwNmlvadqwXUNu5YXwEqKGetZknrW/1q3mLAQg8NgEdnpkN3Lo6bwo9xVPrb4PEUunPg9pK9HMY+i+lf+j5c+y10jv5NCbb2M0NdEUKiOrwklvV0a15LYdwnOfis302IBhohs8q/ex+mvYWIQQgMCTENjpkd3a7ul8St/s8nwi7/f7U6UuSe+ss6n52umdHL4j9BaTsr15ak+7CtWhqj16sl6li+aSIc9mpb13uuQ8e4oBHEIAAhAYENjpkV0yfVkK/TDj7MhkDU54KuaKrpfYyeGMyOTmOOF25dqduc3mTC7uhPUssDxrfy2azCkIQODhCez0yG5n93Rf8eQpz+Y9+PthhcpKhqt5eQ+eOW+T3smhL0vavGyvhdthWXK4L3/GbRaZzuOTPSKrZvWm/fffX0mYNAQg8GwEdnpkN7t7Ok8j9Ejf9/75ywLpDaWqrw7pOYqfr+yZENiq3yd2cpDZn7HxwXamZ097Zu2acZsFs5merKunn7W/ekuRQAACz0Ngp0d2g7un0/21np8rreAkT62lJ4cr6+mRaTs8wvFSVW4icKnrJfZzyD11ji6ziY4MVlBR09yuGbft8IayOeR8a6hnzeRZ+2vdas5CAAKPTWC/R37sdh6zHg7HCHEeAhCAwK0I4JFFGg63GnHUAwEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCPwlge+/rPyO6obDHXUGpkAAAi9OAI+sAQCHF78QaD4EIHBHBPDI6gw43NGgxBQIQOA1CXxt2/e//3/9gPj8V/751HI4PHf/btv2UuOZ9jKe5dgfjsNPnPn5y1xBJODwMyL4CwEIQOCvCeCR1QNw+OuRSP0QgAAEfgjgkUUCDj8jgr8QgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEI3JYAX7oUbzjA4fvw4Vc4wMHfuX64L6I+uh+7bfSjNghAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAwOsR+Ni2j+u0+mvbvAXz7QpVXFb/9ThcoemPqvLtMCTef2f+Zfu923KG/rPbpZ2+3QYkEHh1Atf2yLporxGZ1HND/e/b9rVtJ3nAa3N49XH20/63Q9f8HJ3/d9jv56trJYf6F+Pq1HZJv1+aafUjgMBrEzjJI3+f6O63bRte4RdEXvR/HBzfx+n35vs5yAd5Ouj4Z0m+rrjFxFEZygz1619PnTfsVvh14OXDoZ6CdKFHOUu9xU7VqJyzTj/JnmJeOZxVUbLlYen3PHWRdNF/9riaGfN1tbWKWY3IIfBIBHZ65PKC8X5XUq5wofk8vHIv55jTKUUUuTzfTmYk+DqEuuQ71C8/65iR+WfpnRxUXdpm+81EeRyBLO9V6x78uzVqO/BxLSq40NM1WyLUPlRiWG/qT7+Z8tQzk2eeo+mnH1dDAu+H+5XhKYQQgMD/Cez0yIJ1hjPqkSO9nkKRlJeJjj3+WzjuLKtSXf95pu7kMHT0vcav+NrNAtrnYQ461NmFCz0yYPhv16Ow996Cn/ULqeO65UX/TF6y7Tk8Q1Xv9xwb9zOuhs0fdsowJ0IIvCiBnR5ZdH7vQbpDsc70LLPO6Jd0V3ieqTs5fM8XYdwQ3RE7slpeGuUnE2pCOdtbOtNTCpbDrmdWb67OOSwtZp/n2VPM0+EZqkq/l8M0+2/H1bC9n/NRNMyPEAIvR2CnRxaX33uQvo5hnU70Psg1n7LG1V3Seabu5LCOTHLuZckxPX4+v8kau/fsEWWmp+NKSdczq9f8hdScLU+1i+dSJduew1kVi7Kl3+92XA2bQGQaYkEIgf8IpJ/6TzpJ/d6DFIey5942V8a6n+0KZfuppu7k8PnvhoXkpBpljx8yZQMz83bQswg2vaWntkjVdT1lc4SDZepPR5/ybMJMnnl2ps9QVfq9HCb2HvVl1W3G1ZBA75RhNoQQeF0COz2yAM0u8gW+7jJSyZ7nAZ6maBnK9/KqtOuX/FRnt5ODqvuMR1991U55vCA2tESPeZJbydadV8mQZRfpomdRb+rPfkl5VjSTZ56d6RwSO4v0fk8lab/S7o7sL91AXHVcDZuTgX+YASEEXp3ATo8sTLqidKef04IFxO5BvPFsvTfP9/KuVK8olT3ZRb/c0GIuMjN1Pwc5MldhDumpZbO8oXMqoXZp70MaU0JIOSyrZ9/zqVvqNGoLF/WmnbkgmfKEX+TuL9e1P+Eu9l3I0bKl35Vf0O5qXM0aknF0lgc5BF6XwH6PPGRU3JMPh5nvWfhLDvfctEe0zQOpJB6xLUObFVnLAsAwJ0IIvCIBPLJ6HQ6vOPr/us18neive4D6IQABCEAAAhCAwMUJaAnCD5NTvx4V+PFynvI3ioqwHOZzmnLq1MOFnaeq+n3+C7bLxvzmXjufFVkhCQhAAAIPTMDvaZY23FVkUiz8zTP50rrfHF42MvXnE7npw9sxZLDfAyvPM34T2H6DgrIQgAAE7oiA/OnaoMt68HVdtzx72Xb1PV3vP1vYy0xRHyFVS3upPLumUfbLff/kHm6oKy9Laf/C+hZhpr9wc71F/mPO/39yZTibdwYSEIDACxFIZ1Sa7Xv2fL+k5PFhepayZ9rTAu9m7m/Rf8Sn6qzzaELfNs1s3ledu8Ndr1/hdNNyAdN25oqZ2uX8nr6coV/BIK0t6YxAyXNYMDMUPXmo6OJmKkJIoSKBImKfrrmlqa2nh/rN2fmJTEZBAgIQ2Eug+778XMKe5SM7yhJ15O7lGX2n36tz8b0W/+QrBe0BZ1+SlSeVU86IJTt9256u3FXktOZU/f3lpJ8W/Pe3VOQTqtcmSV7CvzOXhN6dcpgRn/yAwnaYrJjbScoVgVKb9bgtUjiT29qS33ISEIDA6xJYhwp5xjUdeZb+i385D0g9KXfEWlcxPJuTrdne8XTiMw+Y9mRFJX9vYAk5JX+qKjE7T+lzR564rLtDBbPhRVUe6kc6bJUihA+Vs0e+JJbaenqonzlTB4UEAhA4mUBxhcVVZUSZqda9eX8moTlK/qt7/6xx6O5nFRV52pZzIAUM15uTBk+MUlVx1j5V5Gmql/j66p+LZ2IRmUpczEZ5b2SZM+2PTPq1FMekHjZKd5dYm03oaanVjFOaladwY87U0SGBAASOEMg40V1hcZRDXfJEuQaobMXnZlmd6s+KMs+etDx++aZcLjHlDKB4TOuf2VnyOzKdqn/h7odVZ72ld2RzNsqt6AmHBBmswzT+96t5qjT19+BnM7Jdae1MnnlIQwACr0Wg+z47Lz/qXxOxZynBafb8xg7Rvn6tf3FWsS2/0yrPqMUx2X90zjSz0+2SAbbWe9J26nd7S0MKLp/NFc6joculesIhQbcXOlR3X2oHhCpN/SUM581H4WmDZ3Jl0D4dZyYBAQi8BIEemRyQ5Ivt4GY40rPoo5zOKaevhbWy4FZyusipia5HLdIao9IKTmlnqaXYqbMlvyPTGfrLwyTr95Kjo51OebXQYdUGZ9yycJjIjlMDlc32l0p1dueELJfvcs3QStQvucabjS2roHmqNJnINOxchBCAwP8JpO/I9Nl0it8/W8+jFNTEorjdU43fs1XyVJ13nj9nXXduKuZBAAKPTWD/jf9jt7NZ/5vQkvOMpvhpBZ6qPm0LaRgEIPDnBOSay8ren1uFARCAAAQgcGsCWkoa7pmWKcpwDbP0VCP3Pee3J1LunYELO69h4UznNdYbmTPNaCOHAARekYD2NcxafsvIJBtUY4lML/VF1/L0zi/b5vtY5bnUbwLbrOuRQwACELhTAjsj0wWnEbPIdD+ALtjY4d68sr3NDc+HcH3XeJ51kWEiN6rk8mnKc3tekee2OtlfJIWPtwIWuWzLibIrKgpLK9K2ZFX0r+tVwTuZhZcGcggBCIwJ6B5cLsBXuDcBa+O1pjXOabfiq927zDO/fJkz9+p/GZn6lq1H/KJrMjei9LxaC/UpJTJDOZWHmS0nWymf5U+53sdSaMk5btHjthR5UXXSrnR9AEkaZvpncte7tsfZSEAAAndBIN/0TM+ld1/kg8od+vAin33hVI0c+lY/UkpPdyqUYow91MwehUkF1JxDqL0ZaGVJ5lccVZ5T9ZeXT7OZqiK3n5XJ6zB+73TuhY+nX0Vue2Zy2a8PbeTqYslv/kVu/UrsNF5zHb/0zZypYOQQAk9LID1IOkS7MMcPI8giFmai+53rRab8fNxDf9FViBT2Oq7OPBue8Eu6FHTXFLlLzeR+QpmDpK+SXSMyqUaRmemfyY+2yxlIQAAC90Kg3Iyn0/ESnBOe2cycV6715W317MM8jnnWfAaXtDnnQLmDIN8Bmhm/U54zm2F7Z3pkT25w6I112MhGzSj9PjK5Z/NJj4VKuGsy6uddS2nv0QihVrulHUKRSKG/XjHTP5NbW7HTchIQgMDdEVhEpvQ+xe7hRZ5LLt3v9EmAdBYDSkU7Dx/9i65uZnJLyEN6mdkaeiL15BaMInfBmbxsXnAwK/mPRghVtNP4XL7ji7HuIxIQeH4CjijewqA2z567pHdLOt5DJT03mzP5yfyDftFVUyJPjPygK5/tDe8SSkjIvsi0s70dfjX4aORw/lRSvuOei3gZY3JDylCPdWYpC4cJG6ybGB+mhj31ru1R3B0agBACEPgDAg5IWqfylZ9788p2O93Ca7XHy1MWWk8Gp+Fdv92xl4zObv/jftHVDteh3RC8WpgkdTbjlvMPE7k6l3pSrv5V8aEH945HV5GBQZtoShcU/Vn1YjOI9TvRB6RPnVTv2h4ik6mSgAAEXo6A4lBx06dSyC2Up5Yl/5BAzrqGGRBCAAIQeHICvwktuZvjyTHdsHm5seWG1VIVBCAAAQhAAAIQgMC9EdBSkp+x38y8v6p32MDhc5Rhzv3C38yBZrUwN5qRQQ4BCDwbAb8veeOG/VW9vZmXjUzD50Z6aNHvAGY7Gtby3gQkEIAABCDwVAQuG5nKfm5tmSsb7oUvd9NlqZm8l1p3Q+49yzeOU57b/4rc7yeplrLRLreJK4O3zA15lpefVFepojQnbcvXmIr+db3dzlILhxCAwAMQ0N297tn1zkp+PVMeNreMr/NrJ7Gc2nkbwfsWKe9X9u72tMeeyNOOrNf258qYPJ3ze5vcGfpnW+FtVY6A9LBZcCZ32cxgYU9kNrVOeVKepWZyvx+WI6G36GiEUF25uTxr72lFL3ffTP9MboWLdjkPCQhA4K4JyEW+b5ucuF7G1CtKlujFJt3wLvKXeYA9yKntL57Fek79gqrs95JaujxXkQ/ATtW/finHVaj5qsgodKga3cDZ2107nXup0d1R5LZhJle7+HKrQZGAAARuTcBzFH+ETV/6KR96sGOd5berdQMWjs95hglboojoN3kzczrrWUV2zVmw3/sPtwvv0b/+Dl6xKidJskcZZvK0OYGkvKRLjW5CkbvUTO4ngu50FSn5HVCL3PqVsBlF3g81RbO2mf6Z3AqtwRISEIDAgxGYRRp58PIo4m3bZvn3eNidaNIh5vMSRQKb5FW4mSfaKc/I5CW+vvo3NN5RvJ8ttWejcm40k6fC30cmQ8snPRYq4TklX25N+KQhAIE/IDCLNGXOZMtm+eVh7d361MQa9iSe4AutJTIVIBnIM2fKDWrntCP1ZPcVudXO5GXzgoNZyX907qKKdhovPirCl1vdRyQg8KIEZpHGH80rz2kW+XP1TM94zmaqWh73C60lDonDbA/eTG56JSRYXhLOxpdbPWgLIgVsx9R+FgkEIHAXBBaRxsFJqz1aWFvn1w3yb/bmGUrftaz5hDbmKa0FPXtkl3VCAdL2S17yezXvDP05NZHyrLHUm6uRXopUKa8iFnnuPXGjZglVp39TT8r5citfbp2NH+QQgMDzENAyZkaCC7YtN39fUO0rq/Kt1StDoO0QgMBLELhGCMldGC8B8SaN9BT5JrVRCQQgAAEIQAACEIAABJ6VQJkDaclu+FxdT6dyU2IyKZvC85TT5bmX5WckhnYy9zqDJEUgAAEI3BGB2XMjv39abL2ryKQ3pbzP26aWQGs5CQhAAAJ/TCD3aOUbrCnPJ/kp9313bu7S3ugsor1qxTOmHmfu28oXb60KXM4t8i2Z1O+vgp6hX7Xk3vffd9iN50wLg3Nv+iIbpyAAAQjclEDx7I4flsuNlq8BlYChMKDFK7915GZIMvsSaNGvFypVds+OKdtZnKzlNkOJU/XrS6b7X3bJN1JL1ZqjKEweVZj2Z8TNXfu+kyjdoTyO98WMcpgVlVMcQgACEPgbAumYtAYlO1Ke3lxniyuUt1X00lfA0y1aksKZfgUqPbwpwWwISHpKWBq+06rip+rX+0Zp+dCMIkySOvW5bY76e5bRzKeg1rRPNwFuda/OxYth/bCEvZ4BCQQgAIFbE7AL0yMTu2DLh49Mirv0ZzelRJ8bUEv8JEYhwc1b6Jfz3bmAphXFPgWxftfoxEn6119otc6SWIeKgqKU1aHs77uZE0vqSbkj1lBzEe78/l4pxSEEIACBKxLI5zEOS5pz6JSXjNKIHpn8MOlj2zIyLb4EutbvGUbW29NeHCvrjdmuripnMF1nkZTGlrPDwxKZFEK8VS8jyrC4+PcPXmS/uIFeRHV47vFsVstJ634LJZyCAAQgcEkCs7mF5PKhxen3aYR8ot1xRqZ87pIbJY7qzzC5aHDqyQ3cs3ZJ1UlLWCdlln6j0OF5kUk/hlTCas6NChad2vNwLgue0bosThoCEIDA5QnMPLjl8qrp9GeRycY5Msm3Wp6Pf47qPyky+SckbKf1Z+1On+SOS5ixkkWiF/GzOi1ven4zU2L7y/ROS5Fupudh3qlx0oQpe2RmCXIIQAACtyZgD1gqTrn8rLyhF5GUUPwoftaRyb+JbuUOCTP9yulsLjhLpJ4MosXOMvPYr1/1LmYqQ8N6ZHJAUuQoxLqSbFdZ1lNwUgPLWmvJ2dUWyUlPpEpZDiEAAQhA4C8JKObtnMbtN7SETx/u11ByZjwrp/rhni2CvRQSCEAAAhC4IwJ37spPmgD5Lek74ospEIAABCDwNAQUMsvK3tO0joZAAAIPT4B74YfvQhpwWwJ+BJh7R0814aR11FOVP0p+L0eflMg7Ki2bn1RcmbUt64yCD1FEzxHKPuczLC96jo6rfOfnaObjGe580el4A8gBgRsSmG1v0XWkcJV7IIemrSNT7s0ZFn8O4Rm+Ui/p56YeK8kNqEed8joyaQOUO9RVDBOuV/uYnOdScivcnygRZX/BkrPoOTrqLhyZzv41bn/5VJuJ8zWm3Evm7+DlRTtEsNBT8mddQ14lvxAPc54nTP15E1fkR5WX/PZoKS+c81TZQ9j32hUP6H4pctk5vJ5LFaVFOYFInZmWn82CQzvdruysot+onVkJjYcz7E+rSjqbkKeG8nxot2cn51CJa1FD7Nos74nCx0XSS+bFMqt3JleNpb8WnIf90s2WpGQuh7PgMZTrhX1peN+2bH5Rq8OhEufUZbgnMmW9b9vmkPkRNrxFepHf87/UY5PuITHrR8svH5n2v6cyG8ECl45V5qp3fcG8Hb744Jb0zyXM9MzqtaphYqhfb02pIjtB6fdYtFwjWC8J2S0WXColA9LO2c11mpr5Z3pm+VOu95PkMtwLxU4ddjuLHje5y4tE15JZZedmu0pk8p3K0E5ltjMtDD2QUn+xar/9hY8/vORhYHegertHdttdNj+ToZZKm0edWi37dSrHlYorzrmxvYGSzPjLL6t44TnjNpPPxpUM6DF4oae3QvdJpm1v3huuPDlgpM0RyGV1Gyf558HbSJvfSFEnapAYUfas3KteZfEAmCWkJ52J0llcg0TyWf6ZfFZvjpm8O0lEs7JF7mvN7ziWD5A6f+/BIrlKZOqDrNSqw9nI03zIF6rGnK6KPs6seRg5/JLpfk9qhSUx1O8mpHmi75HqPOkZdUM05OBsLpjKi1V56PwSdj2ZuXjScurol3D389w5GBbZsl1CYWuP2pkDwEBcXInUX07pIvdQ7GdTknoyuixQZ5FUpYlFTp4cITRy5K3kCHL9IF+OlpfRt7sWF47qnfFPgHY3KjIzfiYXTIXVjrQbsNCTrGxMeuSMLiVo2Tku5LoxykmJDLYT0KuBvort0N8PAUxVyOPLNTtkZu2Z1nKCJTrMyGed/hibxtVOuTX3hAab5H2OpYb3Ul2i0eiWZoT2FgSX6j1YJFeJTOWyLFX6cDby/JFWXU4aQB4ELl4SHjSWD/XM3IT0G5wSeQsw1J8XvL+AUNoluVxquQ1xA1OPL9E0JjO4gSVR6k09w+Ilv7XZo5UwUPKrX2Y8rc1mWDJM5DJjyZAclFaGo3bKm5u5b4p1/+taSrssV6LYvxgnqadcAnkq9c/kdhb24P7ykzV7QKaSHGa+F/bIzKpLesY/lftzJ0JaTlnhTD7rLxUsnGfjasa/hJmLRCZHYjlWsbXm958Ft4yIGVEcrnLS0wezJKY66EcAAAWrSURBVD0AWG1GO13IZpXalH+hJzPP0n31siucle1RLXMWPR4ts8QfRyabnk8gSigqh1qjUMF0uL5Q3dRSUId5o6GbTedfJ4b60wBf/+XKlFxuMatwNid0Noed9OuSUNemhpJe6Jlxtjwn3Tkmcp5R9CfP5FCscnOKvBzOPGPxUBksF3aqXXbNWZeun3zakRByHKrUTvuLnY4fUlLQ2Z6h3CNNrk0mnRqZCpxFB9nCvA+bWZiRb2h84WA9XlqUJMeVJJ3zul9Ssyq1K89VOCnJU6l2KHfI0fjx1afEzsgk/qprT2RSL9s2HXra4e6TE/Do7fnXepy/JKw/g7HylIhSCubhEKYzFD2l+/phDuB+9kxJH2RDRYuRrfxaSZAHzEtCZ0txX8+uy64z9cyunNm9mLUN9WePriPTwv7SEF+0Ke+BzYY5kfk15fdqT9o5y2+5rweNKo31zs14S73Wo8TOwZDLUEVD6hdGZVjbaT9StOkwuyP198zF/sU4ST2lVJ7KKobyFNrOnZHJ46TAWQR+2TPjf8HVvGKSx5UNKPdeycHQZvw1Gr2UVO79Z05zKE+hI4Tm2RnzHMAyv/2vZ+pry+24i/3WkxnKmtiw3p16Um3uqijcSo1ZqqcfYM40HFLuISdm2ezydFn6UBePu7wUH0YO1VX0lIK2Z50Y6k+Pv45MGSo87VONtsf3VkVe8s/s3KMnyzp/Chdfwk1va0fZI1Zq08VTPE7JoEP1Ua6zDTta2XRnV9S6OU4os/tIjw1UnT34pezP/pX3TPN8t1HablNTnsFAqtReeUnPxjwg7T5kQ9YrtR6ZWUtJz/gLlBgqj6dWQ+NnPBfjSpbk6JJkpr9Y7sz2jLJQlsuB+lTxp+ncfSo9te/t1pHJdWXZVOiQaWFP5GOtNNgRXQPAqmb5Z/JeoyR2L5ojui06q+E0K5tysbJ5NnuoZ9iJKbz8nCkf22ZNPZ2tyoU1hyIjc1k5RE1mvVZT9PjKnOkp+cu9m+tyouRP/fZ6cgo6LFdU+gVdfrI/Pa+rsHJd4Za7sbaqJ5w5XVXRUzin/VLofUfWny5DNwdeTFCerLdUvT8y6RlGjuahB3RkWtiZ/NOx+prJLQMLPgaSnWIsPeFLWhdVlvKpMndJU1OhObjffSswjEzWn5VaYY5AC3vCz0XUoeZv5d347HpXnUKPh0V/yZIcZpIUPevr1BXJaXjNTUpsm12K5MPIlCvbZrKOTNafrGy/7zgtmSV8PaYeK+/WDvPnoEo9s0qtX3aWBT2dnZUtco8ZP5J0hqKnD78iuXBk0sVf6uAQAhCAwFUJ2APeeWIG4dpmX6rea+ux/ktGprxtcQUkIAABCFybwLU9O/ovS+DoeLhkZDpaGRkgAAEIXIPAZf0m2q5N4BpjAJ0QgAAEIAABCEAAAhCAAAQgAAEIQAACEIDAkxDIvdpP0qSzmgGHs7BRCAIQgMAVCOCRBRUOVxhcqIQABCBwFgE8srDB4azhQyEIQAAClyPgt9a93dDvbOe79/nO01PK4eBXyp+yf/t7+LRXlzwc4GDnfw9+vgY35goiAoc6MjiGAAQg8FcE8MgiD4e/GoHUCwEIQKASwCOLCBzqyOAYAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIAABCAAgdsQ4Aue4gwHONzDFy0Zh4zDVx6Ht4l61AIBCEAAAhCAAAQgAAEIQAACEIAABCAAAQhAAAIQgAAEIAABCEAAAhCAAAQgAAEIQAACEIDAvRB437bvbXu7F3OO2KGdvkcyPcjp3LH6ICZjJgQg8IwE3rfta9ve76lpjxKZ3g4R9PNfdH4lpcj/zfXf0Sz/TP5fyeukninQXocQWiEAgWsQ+B8I9vuKbE9+0gAAAABJRU5ErkJggg==
是不是还有别的地方能修改这个配置啊，我从网上也没有找到还有别的配置参数。
建表DDL中只指定CHARSET=utf8mb4的话，那么默认对应的COLLATE是从database层继承过来的，如果默认是 utf8mb4_0900_ai_ci，那么说明这个table所在的database的COLLATE已经设定为 utf8mb4_0900_ai_ci。
也就是说，你这个table所在的database可能是你修改全局 COLLATE 设定前已经创建好的了。
你可以尝试在修改完全局 COLLATE 设定后，新建一个DB，然后在该DB下再新建TABLE，这时候应该会如你所愿。
最后，“CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci”是默认的对应关系，不建议在 CHARSET=utf8mb4 时修改 COLLATE=utf8mb4_general_ci，可能会带来其他未知影响。 154、 注意这里说的是必须带上 CHARACTER SET utf8mb4 这种，否则还是collation_server
default_collation_for_utf8mb4
确实可以修改，也能够改变utf8mb4默认的collate，但是没有参数设置
Introduces a new system variable default_collation_for_utf8mb4 with two
possible values: utf8_general_ci and utf8mb4_0900_ai_ci.
The value of the new variable is used as a default implicit collation
values if the character set is utf8mb4 in:
* SET NAMES utf8mb4注意也会影响set names的行为
* _utf8mb4 '...', _utf8mb4 x... and _utf8mb4 b... literals
* CREATE/ALTER SCHEMA/DATABASE ... CHARACTER SET utf8mb4
* CREATE/ALTER TABLE ... DEFAULT CHARACTER SET utf8mb4
* ALTER TABLE ... /CONVERT TO CHARACTER SET utf8mb4
* table column definitions in CREATE/ALTER TABLE
* SP/SF/trigger/event parameter, local variable and return value declarations
* SHOW COLLATION and SHOW CHARACTER SET output
Revert "Bug #27959941: DEFAULT_COLLATION_FOR_UTF8MB4 CAN'T BE SET FROM CONFIGURATION FILE"
The default_collation_for_utf8mb4 system variable is intended for internal use by replication.
Thus, it doesn't have command line and configuration file option counterparts.
因为这种建表的时候并不是依赖collation_server，只要带了字符集utf8mb4就会使用默认的字符集，因此除了collation_server
控制默认建库建表行为，因为默认建库不会带字符集，还需要控制mysqldump和建表加字符集后使用的默认collation问题。
因此在
init_connect = 'SET default_collation_for_utf8mb4=utf8mb4_general_ci'
这样设置，这样设置管理员账户不生效，主要是含有super和connect_admin权限的用户不生效，普通用户是生效的。
但是这个参数官方说的是只是内部参数。
但是对于collation_connection 并不生效，但是这个值影响的字变量，影响不大，会转换
mysql> show variables like '%coll%';
+-------------------------------+--------------------+
| Variable_name | Value |
+-------------------------------+--------------------+
| collation_connection | utf8mb4_0900_ai_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
| default_collation_for_utf8mb4 | utf8mb4_general_ci |
+-------------------------------+--------------------+
需要设置一下也加入到init_connect 中如下
init_connect = 'SET default_collation_for_utf8mb4=utf8mb4_general_ci;set names utf8mb4'
或者
init_connect = 'SET default_collation_for_utf8mb4=utf8mb4_general_ci;set collation_connection=utf8mb4_general_ci' yejr 发表于 2025-6-13 08:53
建表DDL中只指定CHARSET=utf8mb4的话，那么默认对应的COLLATE是从database层继承过来的，如果默认是 utf8mb ...
重新测试了一下，建库的时候不指定字符集，是系统上配置的。正常来说cs这个库的默认字符集是COLLATE=utf8mb4_general_ci，但是建表了之后还是utf8mb4_0900_ai_ci，还有别的地方有问题吗？
mysql> create database cs;
Query OK, 1 row affected (0.03 sec)
mysql> show create database cs;
+----------+------------------------------------------------------------------------------------------------------------------------------+
| Database | Create Database |
+----------+------------------------------------------------------------------------------------------------------------------------------+
| cs | CREATE DATABASE `cs` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ |
+----------+------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> use cs;
Database changed
mysql> CREATE TABLE `t_local2` (
-> `id_key` varchar(20) NOT NULL,
-> `detail` varchar(50) DEFAULT NULL,
-> `memo` varchar(100) DEFAULT NULL,
-> PRIMARY KEY (`id_key`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.23 sec)
mysql> show create table t_local2;
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t_local2 | CREATE TABLE `t_local2` (
`id_key` varchar(20) NOT NULL,
`detail` varchar(50) DEFAULT NULL,
`memo` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec) 乘晚风 发表于 2025-6-13 09:18
重新测试了一下，建库的时候不指定字符集，是系统上配置的。正常来说cs这个库的默认字符集是COLLATE=utf8 ...
执行下面的命令查看
greatsql> show variables like 'collation_%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | utf8mb4_0900_ai_ci |
| collation_database | utf8mb4_0900_ai_ci |
| collation_server | utf8mb4_0900_ai_ci |
+----------------------+--------------------+
greatsql> \s
--------------
mysqlVer 8.0.32-26 for Linux on x86_64 (GreatSQL, Release 26, Revision a68b3034c3d)
Connection id: 183
Current database: performance_schema
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.0.32-27 GreatSQL, Release 27, Revision aa66a385910
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn.characterset: utf8mb4
有可能是 collation_connection、collation_database、collation_server 这三个设置不一样 乘晚风 发表于 2025-6-13 09:18
重新测试了一下，建库的时候不指定字符集，是系统上配置的。正常来说cs这个库的默认字符集是COLLATE=utf8 ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
The default utf8mb4 collation(default_collation_for_utf8mb4) is used in the following statements:
SHOW COLLATION and SHOW CHARACTER SET.
CREATE TABLE and ALTER TABLE having a CHARACTER SET utf8mb4 clause without a COLLATION clause, either for the table character set or for a column character set.
CREATE DATABASE and ALTER DATABASE having a CHARACTER SET utf8mb4 clause without a COLLATION clause.
Any statement containing a string literal of the form _utf8mb4'some text' without a COLLATE clause.
baguai 发表于 2025-6-13 09:10
154、 注意这里说的是必须带上 CHARACTER SET utf8mb4 这种，否则还是collation_server
default_collation_ ...
set global default_collation_for_utf8mb4=
utf8mb4_general_ci;
会导致查询sys库部分视图(比如sys.statement_analysis)报错ERROR1267(HY000):Illegalmixof
collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for
operation '='
需要手工处理下 Uest 发表于 2025-6-13 09:36
set global default_collation_for_utf8mb4=
utf8mb4_general_ci;
会导致查询sys库部分视图(比如sys.sta ...
是啊，所以说不要轻易修改默认的字符集和校验集对应关系
页:
[1]