Mysql字符集与校对规则

时间:2023-03-09 07:36:57
Mysql字符集与校对规则

字符集是一套字符和编码的集合,校对规则是用于比较字符集的一套规则。

所以字符集有两部分组成字符集合和对应的编码集合。比如说,现在有这几个字符:A B a b, 假设它们对应的编码分别是00, 01, 10, 11,那么ABab和[00,01,10,11]就组成了一套字符集。那么校对规则的作用就是规则A<B还是A>B。假设我们规定A<B,A=a,B=b,这个规定就组成了一个校对规则。当然我们也可以规定A>B,A>a,a>b这样也是一套校对规则。所以一个字符集可以有多套的校对规则。

查看mysql服务器字符集和校对规则的方法:

mysql> show variables like 'character_set_%'; //其中character_set_server就是当前服务器的使用的字符集

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAlQAAADfCAIAAAC/EtpMAAAeZ0lEQVR4nO3de9Rd07nH8a+2esFAtXSIimKkGkVRRZtecIgeOkQiNKJR6lqpWyouVYfTpi7R4BB1iSIhUpdqjTJKncSrTVvaoihDHVRUjNIqDnpxVM8fGe87dvdac85nzr3W3mvv+fv8tbL2XM985lxzzSdvst+9mTRpEiIiIllR8RMRkeyo+ImISHZU/EREJDvdKX5DLYrnqwreYZyuMWbrGZdrPqvij992vtpM7KH67r73BU2p5KKbP/mVPlcV1r8Og3RN7P7eeZw0xuJXbSZRoXp435u23noy/yJ9rOfFz3O+88j9rpnFr9ZM+qL4NW29dTJpxr/HDA1LTFGkaSZNmjRUMPJq6x+Lx8WHofWk69XSNIzPlb/fYpzgoCxduybBH9+ej/F8Mcm0OJ6RdhjfdWzv19Uy2K9lnlvPWNoH4/hfsvTrn4fO8/EELx770zMGF+kbI8WP4b8Dup6N0gfYcjzC//AEH63gQ9uWnjG3Tvp1BWnLYahsCwv2Feza2NiSvyUZz/nYOY8SvHfFrl2p+u+LPf+oay39xuZgySeok5si0vcSih/xD7/nZPAlS7PSroPJF5sFOy3ddEYUz5fGd51xxfFf5QriimPnusqfvyWfStIgdIs9KVnaG/stBrf3GzXkYHx/TEsXIhlJK36lZ4Ibh+t5i30O/ZmU7jKuBpbeLRMStRnZ5y15/i39BtnvV3DOO+GJE3XfXaGM9zSYUmz7IPv9rerOBi+p5IaKNIK/+NGy6IMbRHDjiN0yPC09+0LrcILtjb0XJ8Gej38gCeOKjRO8L8Y8Pedj5z9K7PzE3peEeQv2Zek3dryx+cTGt1yVfBNFGqe1+K0Q3CBoeRLaWg79K9f5hGfP068npj/PqAQ809IWytUpoXkojVMcoCVO6XhjB+uP70rPkk+s0jiWfom8L/b8S8/787RPguuS2HxcwduuisrK2Fik6Sy/6pCw6PWciPgNOTQzvp5oGTSe4pf8wNTxJIuIiFRGn+0pIiLZUfETEZHsqPiJiEh2VPxERCQ7Kn4iIpIdFT8REcmOip+IiGSntfjpN/OkCbQORbovu+dOxU+aRutQpPuye+5WFL/Sz0ByfTaSzut8Hee1DnVe57t/3vXcDT795CdNo3Uo0n3ZPXcqftI0Woci3Zfdc6d3e4qISHZU/EREJDsqfiIikh0VPxERyY6Kn4iIZEfFT0REsqPiJyIi2VHxExGR7Kj4iYhIdhI+4aX4oXAd5hDVb2nL7D6VbqDVtw61TkRcsnsu+qj4BVtmd/MGVN3rUOtEpCi756IJxc9OxS8HKn4i3Zfdc1Ft8RtqUTxpbG88X0zVHsczLns+QwVp/UqbqPtVeol//ksbJ8QRGSTZrfOEN7x4NovSNq1/9JSWYF/BrqMa+/uyjKt1UBTGaO9X0iSsw9KTrji6jyKDrL6f/ErPl/biOuOK47/KFSQ4tNhxtY6IQvGz9yttjJMWe79c8V1xdB8lK9kt8gqLX3AzsgS0xynGjOrUn0bU8VBZ8bP3K23qW4elJ6OuFRlU2S34iRMnjhzbBz/UovTyqDqUFqcYM6qxP42o4yF38ctuPVWhvnVYejL2vosMpOwWeVrxczVu3YnaDvzt2xp44rS9aoxjGZdns/Pn47rc2K+0iZo3/7rCfV9Kz3vap49HpB9kt8733HPPXqfQbcUdMLu7LiKSuQyLn4iI5G7ChAm9TkFERKS7VPxERCQ7Kn4iIpIdFT8REcmO3vAiIiLZUfETEZHsqPiJiEh2WoufftdbmkDrUKT7snvuVPykabQORbovu+duRfEr/awv12eA6bzO13Fe61Dndb77513P3eDTT37SNFqHIt2X3XOn4idNo3Uo0n3ZPXd6t6eIiGRHxU9ERLKj4iciItlR8RMRkeyo+ImISHZU/EREJDsqfiIikh0VPxERyY6Kn4iIZKfCT3jJ63PhusL/aXuDOtv2cVX7aYSxcQZy8iVbg7qfOFX78WY9nL6m3bYK86m1+DVt3kgqQvb2npaxcRo4dSLJslvSg1H8mnbbqs2nvtE1bd5WqK/4VfXXhQp/3BRpiOyWdFrxcz3/I2faXipt33rG0j4Yx/+Spd+08drziY3f+mpV+XSSZ3fEJtP5fYmat7QkRRouuyWd8IaX1jly7RfFlzzt2y609OWKE5Wnp9/YHCz5xMYPRvN0WkeejeUZRdR4jfNpCSUiTZfwk59xrykej2hrP1QolqXt7XtcaRBLv1FDDsb3x7Q3djVwDcozb53k2TWxWRXbp90XT2NXF/YkRRouuyXdheIXu/kaN+5gSrHtg+w7aVT8YGNXA2M+sfPfc7FZeQYVNV57nIQkRRouuyXdYfGz7Bexm5GrvSVObHuLqvKJjR/M1jL5FebZNbHJGOeB0HjtcRKSFGm47JZ0hW94aTtTPG7bd0qDeNrbLzHmab/Trkti8+kkvmsegvNTbJCcZ3ekzVvpPBSj2efZNW+uTkX6WnaLWZ/wMqK4qVW7GuqOLyIiVip+IiKSHRU/ERHJjoqfiIhkR8VPRESyo+InIiLZUfETEZHs6Pv8JFbdd9kev9rfGImNo6UugyS73XswvtKI5u1ETcsnlif/5hS/hPZVjSu7nUIGXXZLejCKX9NuW9PyidXb/OsrfpWMq9ofN0UaIrslre/zswy5qnzqiB88X2H+leRpnI1O2lcyLn/+sUmKNFx2S1rf5xe85ZYcLPlUFb/u42D+nsbG+NXyBK9jXJZQItJ0+j4/y6jT4vtjBhv7JzP2uPP5dL0am09QVOPS9mn3xTiutCRFGi67Ja3v87Oz76RR8V2NLfMQe2xM0p+/Zx4S7l1s78n5BCPb4yQkKdJw2S3pCRMmjBwbB2/cXEaOYzejhM002FfUJlhTPlXFr/s4mL9nMo3x/aIa2/OhonGlJSnScNkt6YTiN9KydLPw7H1t+05pEE97+yXGPO132nVJbD6VxC9OiP+4wvyHChLyDEqbt9J8itHs43Ll7+pUpK9lt5hbi1/miptatauh7vgiImKl4iciItnRZ3uKiEh2VPxERCQ7EydO7HUKIiIi3aXiJyIi2Zk0aVKvUxAREemu1uLX4Tvv9d79DtU0gX13X2rNtnQ29JsnItmt/wqLXyUROum6J/26pOVjn8Co+P21rCvJtjTCSOTWLlzHIlnJbvEPRvFr2m1Lzsd4YWz8ps2PX33rsPS8ip8IGS7+tOI31KJ4vhiqtH3rGUv7YBz/S5Z+08Zrz8cS356/sX1s/ITz1YqaNNexZ7ylcYZi1oPI4Mlu8Se84cW16WDYR1ybkWtL9W9wrrD29q5+Y3Ow5BMb39XGEt/TPnmeLXl2U9p6KL3jrvMiMrASfvLzNPPvlcX9pfVMsL2x32Jwe79RQw7G98csbezK0xjf0r54bIzvGW+1jMGD82aMPHKy7nGJNFl2i78LxS92k/Lv1PaUYtsHGXfY2PiW8XYyb66XgnNrH2+1jB3Fzo/rfHAeRHKQ3eLvsPh1uMlGbUaWOLHtLarKp+74xvFGXWuMXy1j8IT5L43ctXGJNFl2i7/CN7y0nSket+1HpUE87e2XGPO032nXJbH5BONjmDdP/NL2bQeuIKX92sdboc7nDe9gi8G7My6RJstu/esTXkYMOfRLfBERsVLxExGR7Kj4iYhIdlT8REQkOyp+IiKSHRU/ERHJjoqfiIhkR9/n1xCe2SueH+zflDCOKzgDgzo/InXI7nkZjK80WtF1T/p1icpnZN5KJ9BeFLugCz3ax6XiJ1KV7J6XwSh+Tbttsfmk5d/9UXenx6qKn4jYZfc06fv8LEOuKh9/fHu/rqui8myLUDy2j6uqeXCNy98yLR9XnOLJYkqtf4wamkhjZbeS9X1+wVtuycGSjz++JxPj+Q7zbJsT+7iCfRXDVsWTavGMv7H/kra7YwklIo2m7/OzjDotvj9mMH7wVdeg7Pm4ptfYo7/f1hkOjjHYS7Bl8SrPJPinrnjec7k9W5Emy24l6/v87CzJp8X3t3e9as/H1cA/vZYzlvSKy8AvrWUwW8u6Mk6pv1+RfpTdStb3+SWPNzYfYxf2Vy2T789z5Ewd89zaODhGy3j9LV1DCza2jNfVtT1VkYbLbjHr+/ySx5uQT1Twtpdc82CZn+CQ7VNkj+//o0fUvJWmVDo/xYkqHVQxrCcZ+6BEGi67xaxPeBlR3DGrXQ11x+8wsV5n0X80byJ9TMUvW40qwH1E8yYyCFT8REQkOyp+IiKSHRU/ERHJjoqfiIhkR8VPRESyo+/zy0F/vUHRnme144qN0xeTKWLUL/tDZQbjK41o3k7UtHxwf55OD1LxSihC9vaelrFxGjh1IsmyW9KDUfyadtuals8Kxaz6Jc+q2lcy3mp/3BRpiOyWtL7PzzLkqvLxB69kHorHpQ38edqTr0Nsv53fF0v7DpMUabjslrS+zy94yy05WPKxdOGawE6OPVnFzlszeZKMui+exsapE5G+oe/zs4w6Lb4/Zmmo1mtj4wfnqnjSlWds/tVKm73imdj74mlsnzqRPpXdktb3+dnZd9LY+LH5B/MxBvR30auHocPZi11vCXESkhRpuOyWtL7PL3m8sfkYu0ju15OP62TsvHVHbKeemxt1X+xxEpIUabjslrS+zy95vAn5RAVP6Ncyb67ZMKbUBfZ+XeNyzQOG8Xom0N+pSF/LbjHrE15GFDe1aldD3fFFRMRKxa9zK8OqsCasDevB++D98EHYEraFcbAjjIfdYTeYCHvB3rAPTIGpsB9Mg/3hAPgCHASHwKFwOBwB0+FIOBqOgRnwZZgJJ8CJ8BU4GU6BU+FUOAVOhq/AiXACzIQvwww4Bo6GI2E6HAGHw6FwCBwEX4ADYH+YBvvBVJgC+8DesBdMgn+H3WE87AjjYFvYEj4I74f3wXqwNqwJq8LKvb0HIiJRBr74rQSrwLthNGwCW8E42Bn2gClwIEyHmXAqnAnnw2WwEL4HC+AO+Cn8Au6Dh+BReBKWw3PwIrwK/wf/hNfgFXgBnoOn4XfwW/gN3Ad3w1JYArfBzfAtuBFugOvgWlgEC+FqWADz4Qr4NlwGl8IlcBFcCHPhfDgPzoU58E2YDWfCGfANmAVfg9PgNPgazIJvwBlwJsyGb8IcOBfOg/NhLlwIF8ElcClcBt+GK2A+LICrYSEsgmvhOrgBvgsXws1wGyyBpXA33Ae/gd/C7+BpeA5egFfgteGpeBVehOdgOTwJj8JDcB/8An4Kd8BV8D1YCPPgfDgT/gNmwnQ4EKbAHrAzjIOtYBMYDe+GVWCl3q4kERkk/VL83gxrwYawJXwK9oBp8CU4GWbDJfAd+CFcAb+GR+FpeB7+Cm/Aq/BHWAaPwL2wFG6Hm2ARXA5zYTacBifAkXAQTIU9YUfYAT4GH4EtYVMYAxvAKFgb1oBV4C29npamWRlWgTVgbRgFG8AY2BS2hI/Ax2AH2An2hKlwMBwJJ8B/wmyYC5fDIrgJboelcC88Asvgj/AqvAF/hefhaXgUfg1Xwg/hO3AJzIaT4UswDfaAT8GWsCGsBW/u9bSISOP0sPi9A9aHrWAX2BcOhK/C2XApXAu3ws/hYVgOr8Dr8Dw8AffBENwEC+ACmAUz4VD4LHwatoEPwRhYD9aCt/dqbFKPt8NasB6MgQ/BNvBp+CwcCjNhFlwAC+AmGIL74Al4Hl6HV2A5PAw/h1vhWrgUzoavwgEwBXaBrWB9eEevxygi3VBf8VsHtoDxsD8cD+fAbLgN7oFl8Cr8BZ6Ce+FHcA2cAl+H4+AQ2Ad2he1hLIyCVWtKUbKxKoyCsbA97Ar7wCFwHHwdToVF8CO4F56Cv8CrsAzugdtgNsyB42F/GA9bwDq9HouIVKDD4jcaxsG+cDxcADfBVfAMvAHPwv1wG8yHs+BYmAjjYWsYDatUNQCRqq0Co2FrGA8TYQacBfPhNrgfnoU34Bm4Gr4PF8DxMAXGweheZy4iVvbf8xsNu8B0OB9uhSfgf2EZLIVr4Cx49KijHpg16+5589bVexOkA/bfAKn2N0bscVaCdeHuefMmwJfgLFgES2EZvABPwA/hv2A67KyKKH0iu9+88hS/sTANzoU74QlYBj+CuXAk7AoblkXr4fQ17bY1LZ8+EruKotp7WsbGcTXeED4NR8FcuB2WwTIYgnPgczDW2IFId2Vf/BYv3huugGdhCBbAMfBJ879S9mr6mnbbmpZPf6mv+FVyXxJ+3FwVPgXHwlWwBP4Al8NkeFOHqYhUJ7tdq7X4PXHAAS9tssl1cEDof/Vdz//ImbaXStu3nrG0D8bxv2TpN2289nyqjd+Wv+s4Nk7PxSbT+X2xtO8wyVbvgQPhevgFfDUthEjVGrUJdMNI8bsWzrJdYtlkiy952rddaOnLFScqT0+/sTlY8qkjvmvCO4nTdzyZR90XT+PihZVM10rwTbimwygikmBF8TsKjo78MSj4UvG4uMP69+629vY9rjSIpd+oIQfj+2NWnr9rriqch+7ofPbS7ounsasLe5IeR8PRlQQS6UBzdoAuGfnJbyEsmzz5jsWLg5d45qh0v/BsIqWh/Ju4PaXY9kH2nbQn8auat56Lzcozb/YpjYqTkGSpt8B5ML/DKCJVaOZuUKPW//N7/KCDXvzAB26Eg2GU+xLj5jJyHLsZWTZxV5zY9hZV5VNH/NJQnsadzEPXxGaVMN7SLuxxEpJstR4cAt+Du+DEtBAiVWvmblCjtnd73rFkyUSYB8vhJ3ANHAc7wer/epVnk/Xs3W37TmkQT3v7JcY87XfadUlsPpXE9+fvT6bDeeiOtHlrvar1j65RB+MUA/o79VgD/g1mwiK4E56GS2FP/TqsNEkDt4J6eT7hZQzsC2fDYvgfWA5L4GI4FnaHMQP36BY3tWpXQ93xpQneBGPgMzADLoY7YDk8Bv8Ns2EKjOl1hiICMR9vNgp2hMPgHLgZHoUXYTncBdfBHDgGJg1/OrC+3U0G2MrDn8m+FxwDc+B6uAuWw/PwKPwA5sBhsIP3fxBEpGc6/GzPUbAd7A0z4Fz4LsyHp+A1eB4egsWwEObATNgLdoNtYaPCv6OKNMfqsBFsC7vBZDge5sBCWAwPwfPwGjwF8+EGOBdmwGTYTnVOpI/U960Oa8GmsBNMhRkwG86AW+BueBxegtfgGXgAlsB1cBqcASfCF2Eq7A4fh81hNKxRU4qSjTVgNGwOH4fdYSp8EU6EM+A/4XpYAg/AM/AavASPw91wC5wBZ8EMmAo7waawVq/HIiIV6OH3+a0M68LmsCPsDfsPb0bfgoVwM/wEHoBl8CL8E16Cp+BBWAq3wDVwEZwJJ8ERsB98BraHD8NY2ADWgdX0CVID5E2wGqwDG8BY+DBsD5+B/eAIOAnOhIvgGrgFlsKD8BS8BP+EF2EZPAA/gZthIXxr+C9b+8Nk2BE2h3X1L/YimeiXb3IHVof1YTMYB7vBvnA4nACnw4VwNfwAvg2/gofhSXgWXoZ/wN/hheH3HTwAd8EdcAtcDwvgYjgHZsHJcCwcNrwb7gw7wyfho7ANbAFjYWMYDevCu2B1eLu+JbzFm+EdsDq8C9aF0bAxjIUtYBv4KHwSdoZdYDLsD4fDsXAyfAPOgYthAVwPt8AdcBc8AI/BcngB/g7/gJfhWXgSHoZfweXwA7gaLoTT4QQ4HPaF3WAcbAbr6x/YRaRUHxW/ZG+FNWEUbAybw3aww/B/50yDw4a34FnDW/B8uB6ugNvhTvgZ/BLuh4fhMVgGz8Cf4CX4K7wOb8Df4GX4M/wBfg+PwyPwINwDd8GPYTHcCpfATfB9uBFugOvgWlgEC+EqWABXwuVwGcyDS+AiuBDmwvlwHpwDc+BsOAvOgNNhFnwNToPT4GswC04f/pe6s2EOnAPnwfkwFy6Ei+ASmAeXweVwJSyAq2AhLIJr4Tq4AW6E78NNcDHcCovhx3AX3AMPwiPwOPwe/gB/hpfhb/AGvA5/gZfgT/AMLIPH4GG4H34JP4M74Xa4Eq6H+XDR8F87vjL8145pMBl2gx1gO9gcNoZRsCa8tYcLSEQGj/37/IKyfe/+SvA2WA3eCe+B98JGsAlsBlvDdvAJ2Al2hfGwB0yAibAX7A37wBSYCp+DafB5OBAOgoPhUDgcjoDpcCQcDcfCDDgOjocT4SQ4GU6BU+FUOAVOhpPgRDgejoMZcCwcDUfCdDgCDodD4WA4CA6Ez8M0+BxMhSmwD+wNe8FEmAB7wHjYFXaCT8B2sDVsBpvARvBeeA+8E1aDt1X6ey+1rqLg7/nV1K9Iw2W3/issfpVE6KTrnvTronlIVskqKo0wErm1C9exSFayW/yDUfyadts0D52obx2WnlfxEyHDxZ9W/Fz/TFT6N2tX+9YzlvbBOP6XLP2mjdeeT1p813FV82DPszuiJs117BlyaZyhmPUgMniyW/wJb3hxbToY9hHXZuTaf/0bnCusvb2r39gcLPnExne9VNU8tAaMzbkJ0uah9I67zovIwEr4yc/TzL/PFveX1jPB9sZ+i8Ht/UYNORjfHzMYH0Pd6iTP1hlIyLk+xkw8E5IwP/zrqhDJTXaLvwvFL3aTit3xLXHsL3kYd9iq4hMavuWMJ5nWG5Sccx0S1qHx1kStN5GsZLf4Oyx+nk2ndW+N2qRc7S1xYttbVJVPbPzWM3XMQ2tjY6rdYcwkYf5LI/vnXyQT2S3+Ct/wEtyj2/aj0iCe9vZLjHna77Trkth8YuO3NUju1zMPrj/2UMK8Fa+Kuu/B+RcZeNmt/xw+4cVoyKHn8bNblCIidVPxayz9OCIiUhcVPxERyY6Kn4iIZEfFT0REsqPiJyIi2VHxExGR7Oj7/JrP/9tpPUioZlG/AdL9Vdfv67wtectYPPNcPF/VTWnaPDctn8oN9uhKDMZXGjH8MSXNUW0+Kn7+lvZ62UlixX4brjTJ1k3csqG3Niitc57zlnyMXdehafn4u66pcetVfbGqKzMYxa9pt63yfJo2wFolFL/iVaXbelXT2C+3ozTPoTLGIMEJ9/TrOR+Vf4Walk9V/abl2S+rujL6Pj/LkGvNx9hvHeNqptj5Kb3KNc+um+iJ6b/vlvsbdb8sg7LE8Y+3dAilx8UIntxcnXrycY3Lk0PsPLjiNy0ffxz/S5Zx+SVc0t/0fX7BW27JocN8ovr19BI1rgEQO6WlLf1rI3hJsL0lTuv9qiqOZYBR3RnDFl9qY7/QNS2WoZVeGBWky/kE+/X0ZUlG2un7/CyjTotvjGPp1JNAaUqxfTWKPXPj8jBe2DZvxvtrvE2eOKX9uoLb4wTHGzuW4IWeLjz5uHIO5macB8+8BTuqIx9XF548LWkHEw6KajwI9H1+dsYVGYyfMM/GAQ7G8rWPIri0LHeh9aD0fFS/rkyCcYLBk9dbWxtPeqXHxgaxaQfnLTYfV1+WyXHF94RKzsf1qrHfal9Nazkg9H1+yeOtMJ+ofj2jiBpXY9lHUTrPrS/54xQvT1g/Udd64pQmH+zUHyc2bGmbYL9RqfrzscSJnQdjMj3PxxLH2N7To4ex2eDQ9/klj7eqfCz94p6HtgZR42om4xCKM5DWF47NBe/6oewWu/LxxHElX3o+IY4rgqUjexetLw2V8eQTHJenC8puh3HeGpiP5ZJOxhVsY2k2OPQJLyOGHAa1X5FSsctPi1b6koqfiKAaJrlR8RMRkeyo+ImISHZU/EREJDsqfiIikh0VPxERyY6Kn4iIZEfFT0REslPt9/mJdE7rUKT7snvuVPykabQORbovu+duRfEr/Wwt12du6bzO13Fe61Dndb77513P3eDTT37SNFqHIt2X3XOn4idNo3Uo0n3ZPXd6t6eIiGRHxU9ERLKj4iciItlR8RMRkeyo+ImISHZU/EREJDsqfiIikh0VPxERyY6Kn4iIZKf42Z69ziisX/KkkGrsB+i52vfqg/j6aOZFRHwmTZpU/ITTXiZk0JMkE3osrViuP9ovj41Trb5YISIiAf1Y/LovYVqKlxTn2V78WtvHxqmcFomI9L2R4lf6U0UpT/uhFm0nS/9Y2t7StavTTuIY41u6KG3WNmnBUK72sXFix2uJbJwHEZGGSvs/v+L+S1lVKx4Xry1tY+w92Ffw8tic0zJsO1kcvj/IUFnNS4jT4XFwgCIifaP1nz2HhgWvam1ZPHAd+5vZtV2VELC02VCBv30n8S0xXe1j41jyiZ3DtBsnItIUaf/n59lMPceuzbrD0pKQfzCOv2VCcFqKjTGmq31CrSpt6brQmJilRxGRhupC8aOwcQfbR/UeG8eSgyX/TvJ0/dHS3t/Mn0Ynx8buRET6QML/+Xkau17yb9z2/XSogPjiF8zTPzRLnm1XufIPxne198TxpGEfr/98sDsRkabTJ7yIiEh2VPxERCQ3/w+eBdUqVZzwGgAAAABJRU5ErkJggg==" alt="" />

mysql> show variables like 'collation_%'; //其中collation_server就是当前服务器使用的校对规则

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAbUAAACUCAIAAACbTyCtAAAYg0lEQVR4nO3debxdZXX/8XertnXAH2AZMpCACcgkBH4MMoMVVLAmQRkEiiKDiCioIBRQRgFBBcEYMgKFEEgcaoEqUPCCrf6AAiY3OAEKFHgVXgICalux5fcHntvD3cN59j7n3nPuPevzyiuvfZ+99nq+az1rr5ybc/Z57Nxgl112WbZs2cYbbywIgiDArk0sX748+mMQBMEfGWqO8foxCILgFey888477bTTTjvttOOOO1533XUbbbRRtxUFQRD0Bttvv/3222+/3Xbbbbvtttdcc8306dO7rSgIgqA32HrrrbfaaqsZM2ZsueWWV1999QYbbDAKkw40kR3vlPM2/YwaiWpL4irKZ6co9z9svLNKOlsSufXWKbVdqbqxVepjj80222yzzTbbdNNNN9lkkyuvvHLKlCmjNnXu0nbwfmjTyaiRrrbccqSjTuyPnVUyCq4qTdHF/PfOpH3EhhtuOH369OnTp0+bNu3yyy+fPHnyqE3dkXqt5Hms05v9cUSV9FR/7IUOmPhP0UCDEdU2/ll//fWnTp06ZcqUKVOmLFq0aOLEiQMZhoybf8weZ9ejebDobK6qxKUtnzfrp2VQKVMXJaHcf7qexPGsyHp+SiJt03/Rcfq8RZb14kofz/UzkKGeniInRRQlsyQir6y6oD6TJ0+ePHnypEmTJk2atGDBggkTJgyldSBzS+cetzRQsJDl69dydVvWzTB5idrambfIyTANA3l3Ucu5Wk6daJyiP0VMyXjVnFeidlzp+otOlcvuVv6DEWTixIkTJ06cMGHChAkTFixYsO666zYXtw6VY6V6LT+VYpY7dUvxWbOWk+beEkNkx3P9F40U+Sm/qshJkZ90iq4q15+ip+Mycm3q6U/PW+JitdSZ4jwYJYaaYzv9MXekg/VaTrmS5nDKA8matZwuMTnlPtPzVjv/KfO2JH29Wua8HVJk5Nok6h/pdayRkxqpG2hQ6apgOBObaPn7taa8V1r79HpNX9TEOm4Op6V9pXpNmTQlqHp+sj4TjVuuS6LOkvGq+a9E7bgS9afkP8V/p/JfL28DDVKMg0ImN7Fw4cKh92eGDNJLIWs58EqKxmssf8m8JT7LdVYSUJKWYa6KJtUqD7l+sgGm+MmNt2qw5f6L5KXoqUrVuCrpV5D/7KlK/ocZZ49Lgs29tiXt5zkwpYlFixZNmjSp5SU18h5LFQTlZJtsO3dN3HGdYf0mFi9eXPL5x9pr1v5iB0EQdIENmijvj0EQBP1F+uvHIAiC/qLG/z8GQRD0Bdn3r7utKAiCoDcY9vnwCRMmdFtREARBb7BOE/Pnz1933XW7rSgIgqA3WLuJefPmrbPOOt1WFARB0Bus1cSw/hifWAxSiDoZ3/T1+v5lE9EfgxpEnYxv+np9c/tj7kNORQ8/xXh/jkedjO/xovXtL+L1Y9AmUSfjm75e3+iPQZtEnYxv+np9S/pjEARBXxP9MQiCIJ/oj0EQBPlEfwyCIMgnnp8JgiDIZ90m4vnrIAiC/2W9JhYtWhTfbxYEQfBHNmziiiuumDJlSrcVBUEQ9AYzmliyZMm0adO6rSgIgqA32K2J5cuXb7LJJkOnEj83n31gs01JlebNtezrJ0ZHnZGrk1jHXqCv8z+7ieuvv36rrbYaOtXj/bGlZV+v6ygy0nUS69hd+jr/RzRxyy237LDDDkOnutUf04n+2AtEfxzf9HX+T2zijjvu2H333YdOtV/3A01kBxPtE8ezUtP9lMSVrmcgQ715xxyV8pl7SXl+co1r+Anq0df5PKeJO++8c6+99qrqoaRec22afyzpPi3najl1JePyuVLiag5KJsb0eccrNeokd7DIT+Q56DwXNXHvvffus88+Q6cSi6ykLgdeSXY8d5aikSI/5VcVOWkZWtW4miOS6Y/p8445EoOqms8i/0V+xn2eu0VfJ3NuEytWrJg5c+bQqTbrvuX9kOIw3U/WZ6VJy2VUOh7I64/p8445Rq5OcgcrXRu0T18ndkETg4ODs2bNGjqVnpeBJnIvr9Sq6vnJ+qxkXC6j0vFAcX8cl6U2cnWSO1h1XYI26etkLmpi1apVs2fPHjpVKS8llZ3bL8rthxmU+Bl2NtFPSlwl91u5nqLLE+cdc1SKq3zdFectd7zEvn48wSvp63yW9Mc+IXsT9nVBBEEwxMImBgcH+7A/BkEQ5FPy/49BEAR9zfwmVq5cGf0xCILgj8xrYuXKlc2f7wmCIOhroj8GQRDkE/0xCIIgn+iPQRAE+cT7M0EQBPmU9Mf4mHSQQtTJ+Kav1zf6Y9AmUSfjm75e39z+mPuwXdFDeDHen+NRJ+N7vGh9+4t4/Ri0SdTJ+Kav1zf6Y9AmUSfjm75e33j/OgiCIJ/oj0EQBPlEfwyCIMgn+mMQBEE+0R+DIAjyif4YBEGQT/THIAiCfKI/BkEQ5BP9MQiCIJ+uPD9T9ERnZ5/07OvP/Tcx0nlI99/d9e1WMRSFnKi/488+18hb/95HXXy+sMh/pXlLLPtqXbuYhxG93zoVV3eLoZ3+WMlyJLz11X00nDHdH/t65ZrowZu/I/YdiWugiTZdtamhW5e3SV/fZR3pj0UlWF6a6eO5fgYy1NNT5KRT8aaITPHTg3lovrAd+47EVa6/ksgS/7k/puS5pf6W4+lRVPWf4i3dflzR/vsz2UIpP869MGU8e6p85UqMK+kscdsLxy1lj1AealPifCTiSnFVZJmS89r5TNc/0CAlkKrzBmW0//qxyKz2OhUVd3OVpChMrL+WOmvIbv84G2+Jtq7kIXH2FPvceFt6Toyrhshc46HBob+bD8rXq9xhS5GVlqZ9gzbtxxW93x9L/JQrTPRTqfgSZXfqOGXelrJHKA+Js9fW09Jzup8aIkv8D/097KDk8lyb9IWutDTtG7RpP67obH9MOW7pP73uy2s00U+l4qvhZ6SPdSkPRf6r2o90XFVFVtVTO5818pASSNV5W1LVflzRlfdnBjIkjmdV1fafG2ZiyJXiLfJfMm8l/13MQ1Xjlnqy3tLjKtJfNGmiztxIi0QW6UyUlOsn16Yd/ZVSkTjjuCWenykiW0x9XSjjjrG+vmNd/9gg+mMQBEE+0R+DIAjyif4YBEGQT/THIAiCfKI/BkEQ5BP9MQiCIJ+OfP6xKimfz+rULO37Kfff8SnG3Ac1RlTtKNTJ6DMW63zk/Pc0XemP5f4rzVtiOQrrmj5FJSVjqyI7ora8EpqnKDoec0R/HAOM6f7Y9ZVLFFBVZ9fjqkT7aitVQvTHUWas6BwRuvJ8Ybn/RD8DGerpKXKSGG/LedvUWTuukvHOkui/2Sx7XBJvrp+BvOf8yqfOXtIyySn5LNFTnv/0damkp+OMtP+epv33Z7IFV36ce2HKePZU+cqVGFfSWeI2MYSWbhOl1o6lF0q8RE9JjEMUnao9b6eOm38sUpU+mK6/qp+gDu2/fiwyq72u5fdDbl2mCKtR9y3d5k6RrjPFPnuc6H8gQ3lctUl03jJviZ6HBhPjSkxmiU25/TAlJZekRFeuv55Bm4y0/56m9/tjiZ9yhYl+WuoscZvop2X4KVKr5jMllo6QOFGNdayat0rzpkyaOFc9nTXyVs+gTUatkHqRzvbHSrWVeFeU+Bn6McV/bZ0lbhP95OpMsa96bTtx1SbRedX8FHmuEdfAKyn3UyOf9XS2n7dKfmoz0v57mq68PzOQIXE8q6q2/9wwE0Mu0lNbZ7P9sIMiJy3jKhnvLOn+K+WnRHztuFKmyCY2xb5cZ67b9CiKLKv6qcfIeR4DzGti5cqVM2fO7LaiXiFbfH1dKD1P0XplG1M3VRYT9daLRH8Mxj3RboKaRH8MgiDIJ/pjL/Mq/oI3sDprMYEpvJm3sBlbsg1vYxf2YE/25r3sw37szwEcyEEczCEcygf5EIdxOEdwJEdxNB/lGI7l43yC4/gkn+LTnMhnOImTOYVTOY3PcTqn8zlO41RO4WRO4jOcyKf5FJ/kOD7BxzmWY/goR/MRjuQIDucwPsQHOZRDOJiDOJAD2J/9eA/vZW/2ZA924W1sw5Zsxlt4M1OYwFqszhv4C17V7bULxgPx/T3p/AmvZQ0m8GY2ZWt25O3szb4cxIc5hk9zKmdzIZeygKtYzvX8E7dyF/cyyE94gId5jCd5muf5Hb/nJf7Af/ACz/IUT/AID/FTVvEj7uaH3MFt3MyNfJuvsIzruJalLOFqruJKruByFrOQBcxnHnP5GnO4lEv4ChfzZb7EF7mAL3A+5/F5zuFszuQMzuBMzuYcPs95nM8XuIAv8iW+zMV8hUu4lDl8jblcxnwWsJDFXM4VXMlVXM0SlnIt17GMS/g2N3Izt3EHP+RufsQqfspDPMITPMWzvMB/8Ade4vf8jud5mid5jId5gJ8wyL3cxQC3cD3LuYoFXMqFnM2pfJpj+DAHsS9783Z2ZGs2ZQMmsAav5U+6WJrBCLGgicHBwXHcH1/NGqzHpmzH25nJwRzNCZzBl5jHEv6B27ib7/EIT/Ic/8X/8Due4Qke4n7u4V+4lRv5BktYxBy+yDmcxgkcyxEcwvt5D3/FDmzLVmzOxkxnKpNYmzVZjdfymm6na3zwGl7LaqzJ2kxiKtPZmM3Zim3ZkXfwHt7PIRzBsZzAaZzDF5nDIpbwDW7kVv6Fe7ifX/AEz/A7/of/4jme5BG+z13cxj+whHl8iTM4gY9wMDN5O9uxCeuxBq/udrqC4SxsYnBwcPbs2d1W1JpX8Samsw3vYD+O5EQ+zxlcyTe5mR8yyC/5Ff/JizzDo9zPndzK33M1c7mQ0/kUR3EQf80ebMNGTGFt3sifdTvqoPf5M97I2kxhI7ZlD/6agziKT3E6F3IZV/P33Mqd/JhHeYYX+U9+xS8Z5AfczDe5ktP5PCdyJO/nHWzDNN4U/5MwoixqYtWqVc39caQ/UZX1f/t3vvPDa6/913nzVlxwwcEcx9l8jWXcxjX8Gy/wB37FA9zNLSxjPhdwCodyKLPZk3vmzLlr8eL1eRN/PhJhBOjE52RHet4h+/YnrUFRyLmDf86bWJ/N2YE9GTzrrB+ffPKPTzrpFC5gPsu5hbt5kF/xB17gUZZyG8v4GmfxCQ5iL/4vU3lt6bwt9dcKfeyzuIlVq1btu+++Q6dGIi9rsgX7cDi/OPzwx2bP/jr/zIP8hu/xMM9vtNHT2257NRdzGh9lP/ZgUybzhlc6LFHY1+s6iozo/dap9e1uMaT3x/TLm3lD4z+O9mA/Pspn+QpLuIl/5WFu4wUe4NdvfetTu+12KadyOPuwBWu2Mft45vIm7r///g72x014DyfwVa5nkBd4mqXcwEIePuSQn3/iE+9jJ6bx+urz9vXK9Qwj1x87sr6dfdHajoZuXT7EG5jOzryfYzmHhdzAtY03Bge5nks5gX3YpKOzj0k60h8HBga+f8MNK88996HDDlvO/bzEj3nkfe979IADfn7ccSvPPXfzvJd+uf6z47klPpCh3D7RT2K8NfwPC63ouKqfrlNVTL11Sc9Prp5KIkv85/5YNG8l/S3H06Oo6v9lVmNz3sOxXMiX+TEv8ZupU5/abbdT2Ic3tpx7nHFFE8P6Ywo788j++7+wwQa/5noePPzwVWecsSnaeK6+pAjKSzbdOOU4xW2in2H1na31dvyMOUZ5fVNcFVmmr0Wla6vqb17uloFUnbclm/J+TuIGnmMF57NT+vVjmpL+WJ7HdRnk+/zkhBPuWrQoa1B7nYqKu7lKUhQm1l9LnSkKsyJb1ne5hnQ/Xaeqkqx9ebyJfsrXsZLIkvV9+UBmHbP6y/VUEtnSVYqTdINy+y34MP/MCtZO9zJGqdcfp/JvbF5qVqM+csdL/JSvdKKfSsWX6L/csraGqpU9OrR5v430+tYTWeJ/6O9hByWXtyyA8vHE8uiUQaL9FjzOeumOxiL1+uN6PM6MjFnKcUv/6XVfXqOJfioVXz0/5ZHWiLenqKpqlNe3qsiqemrUQ1X9LV0l6k/0kGi/NU8wKd3RWKT279drcy8/5Ejunj9/oEGzzUATRePZ5SwZz6qq7T83zMTSSYmrpXHJjDX8dJF0SS3XJeutZZ5zL8x1np69IuOWIot0JkrK9ZNr047+SqnIzrg1R/L/uIe/TLl+TNPm+zNv41zu5Td8h1M5kC3GxZNS2WJKL6mg9xnr6zs6+l/NFhzIKXyX33IP57J9Z6fpWdrsj0O8nndxMktZwYv8nIu5iOOYxQxW76z0IAg6xxrMYBbHcxGX8HNeZAVLOYl38rpuixxtOtUfs2zIuzmei/kW9/Esz7GM73IF53M8B7Abb+H/dGriIAjyWJ2N2Z0DOZ7zuYLvspzneIb7+BYXcTzvZsNuC+4+I9cfc3kjm/FOPshJXMS1DPBTfs3tPMaP+Ceu5aucwcf5AHvyVtaPF6FBkGF1NuCt7MkH+DhnMofruJUf8RgDPMtP+B5LuYiT+CDvZLM+/OB3IqPcH8t5DZPYkr/iAD7G6VzCNdzM1fySZ3mJZ/kl9/E9vslivsznOIwPsx/vZmdmMJ11mh5eDIJe5vWsw3RmsAvvZj8+zGF8ji+zmG/xPe7jl/y6cTv8gqu5mWu4hM9xDPvzdrZkUnxjXj16qj+mszrrM4Pdmc1hfJIzOY1FLOMf+T738QD/zm94ied5gp9xD7c3njxdwEWczWc4punrf97GJryZiazJ6/jTbkcd9DJ/yutYk4mNr09++Qt4ZnMox/AZzuYiFnItN3A79/BznuD5lx/m4995gPu4g39kGYs4jTP5JIcxi92Zwfrxv1IjzRjtj/VYjQlsxNbsyj4cwBEcz2l8gTmv/PrIW3mIx3ma3/Lf/J7neYpH+BkruJPbuYlvcx1XMo+LOZ8zOJnjOZoPcSCzeCe7NL4idwab8xamMZWJrM0aja/IHQefAegur258Oe4arM1EpjKt8eW4M9iWHdiVdzGLA/kQR3M8J3MG53Mx87iS6/g2N3E7d7KCn/EoT/E8v+e/+S1P8zgPcdsrv8BxDl/gNI7ncA5gH3ZlazZkAqt1O11BDn3VH9vnNazGWo0vQN2C7diVvXgv+3MoR3EcJ3E653ERc7mcpXyL73ILP+Au7mOQn/IgD/M4T/JMY4uFF3mJFxtbLDzDUzzOIzzY2GLhPu7mB40tFm7iRr7KN/kGX29stLCUa1jCVfxdZpeFeVzGXObw1cwWCxc2tlg4j3P5PGdzVmN/hbMa+yucy3mNzRUuzGyu8FXmNHZWmJfZWeHvuIolXMPSxrYKX+cbfJM53MhNjc0VfsDd3NfYXOFBHuFxnuKZxuYKQ6l7eXOFZ3iSx3mYBxubK9zHXfyAW/kO32IplzOXiziP0zmJ4ziKQ9mf97IXu7IdW7AR67EWq8Vvr+OV6I89zqsbW3StwVpMZArTGlt0zWAbdmhs0bUXe/MuZrMv72ts1HUgH+AgDuFvMrt0HcVHOJpj+Fhmi64TGlt0nczfcgqn8dnG/lyfbezP9bec3Nic64TM5lwf45jGzlxHZXbm+hsO4SA+wIGNbbnex77M5l3szV6Nzbl2YBtmNDbnmsYUJrIWazQ254qX3kFnqP38TBC8TNTJ+Kav1zf6Y9AmUSfjm75e39z+mPvQUtHDTDHen+NRJ+N7vGh9+4t4/Ri0SdTJ+Kav1zf6Y9AmUSfjm75e33j/OgiCIJ/oj0EQBPlEfwyCIMgn+mMQBEE+0R+DIAjyif4YBEGQz+VNRH8MgiD4X6I/BkEQ5LO4iVWrVkV/DIIg+COLFi0c+rNq1eDs2bP18FbLuYwVnUr3TU4Joci+Ww/JjqHMB0EdFjQxODg4a9as7APq3dSXQFdE1pgxt6kV/Zh+eVU/nWVMVEgQ1GT+/HlDf1auXDlr1szms1H9udRIS/aS7L9D6f2x2b6qn44TRRKMWy5rYuXKlTNnVu6PRfeqgt/TS37MtU+ZumjSdvwk+k+ZItdsWNJauiqyr+qnarwpnhPzEARjjMsumzv0Z+XKFUP9Mf3ml3eLymt82ePstbk2ibO3nKvl5VU111M4bDAbfrmTgby2WMNPm8ctAwyCMc/cJlasWFHj9eOQWdF9W3RcbpbOsKtqOMw1G8hQbt+O/xSfRfZV/aToqZrDegsXBL3O3LlfG/qzYsWKmTPf23y2/f5Sclx0P7fZfare2yl+yi1rONfUjxJ9FtnXaGe5lkUXJgpLmTEIxhjZ/ljjZss1K/Ez7N5uaV9p9qp+UjSk6G9HZ9GPKfblZuUy2jlOnC4IxjC5rx8HmmjpocS46FT5vZ1+yw1kUL0/ttRZHlqKzmFXFelv6b/IvsRPiYz0eMvHW04XBGOV8t+vgyAI+pfy92eCIAj6l6LP9wRBEPQ70R+DIAjyif4YBEGQT/THIAiCXP4//E7qgbdhAnUAAAAASUVORK5CYII=" alt="" />

查看数据库字符集和校对规则

方法与查看服务器相同。不过在查看前要先use一下想查看的数据库。

mysql> use 数据库名
mysql> show variables like 'character_set_%';
mysql> show variables like 'collation_%';

当然还可以使用如下命令查看字符集:

mysql> show create database 数据库名

查看数据表字符集和校对规则的方法:

mysql> show create table 表名
mysql> show table status

查看字段的的字符集和校对规则方法:

mysql> show create table 数据表名
mysql> show full columns from 数据表名

注意:在没有设置字符集时,系统会自动分配字符集给它们,继承关系是:字段继承表,表继承库,库继承服务器。