Mysql转化blob为可读

时间:2023-11-26 13:05:08
-- info 为列名
SELECT convert(info using latin1) FROM drupal755.system; SELECT convert(info using utf8) FROM drupal755.system;

效果图:(结果太长,只截取了部分)

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA8wAAAAtCAIAAAD0unWDAAAOjklEQVR4nO1dyW4jORLNfzI64foWX6ZSjfoNXS2rgDr7Zp3dsOU+1Mlz0A944EV1KUADf0BD6CrbWlwDzkFKJpcILpmUlFK/wDvIFBmMjcEglZKzf/8lVri4uBAgEAgEAoFAIBCoMWUoskEgEAgEAoFAoLSEIhsEAoFAIBAIBEpMKLJBIBAIBAKBQKDEtB9F9vcvH7Ls01d/x6+fsizLwvpulL5/+fDhy/f0fL9+yrKNMAaBQCAQCAQCpaMWFtlWffr9ywdZNTuL16+fkhagTQpldqz+hn+Kr5/ME0NiLUEgEAgEAoFAyWkPiuzgonJTt8d1KLDIdhJ3La8eOkAgEAgEAoFALSStyH5//zWbLyl8O8uzNeWfn+bL2fhz2XB8Nl7OVi3557OO2vjtLM+Km5LJze/rsRU3e+xxLidaz/VnIbuVPZ+IuZbDjhx2fDamJFSx4mO9lkzy/jfHXLP5cjb/s8j0GS3+w/5xpUr/m2bGlXaeKVaz/D403UE2AgAAAAAAAG2BVmQv33+9zRY2hkWWFTdKy7iXZ8Vw8TZbvA07Wd5/nC3envp5ZjUOO3LgsMjys7H6gh47G/fy495TOddTP1/1Uf8k59IGUhKqUNnK11XPm97Z2DdXqcXspsgUgTmx130o7egpFiXzztD0iM4EAAAAAAAAaBlCimyrztMqyLLEJMvWaqysRFVu1FijglTK9IozPZcykJSQU4Eosn1zPfVzWwvWRKpsTJFNqMMYf7Z4my2GhTyTAAAAAAAAAK1DQJGtFZSLt5lRjJZ3xkyluC4H9UtrhTZTZJMSGkrRHNZiVRr5y3FXkf14dqxpiiIbAAAAAADgHwC9yF6+v77NTTz286xzzbbcFFnee5y/PvbzvP8gO8jXw05W3Dz08mIo++vcjP5v416e9x7Jt8o/6bmUgaSEnArGFG/zh16eyVnIubQhDP+8/zDsZOtZpGyUdpzpOHMZTAAAAAAAAICWIaDIfhv38iwrboyWddE87GR23WnVoHleVYrXRZb3xuXrzrXZf35dlMzL4WFVqVp6UhKqeOznJdvrIlt1eOh11sOHnay4cc51U2Qlf4WVxj/vX/fytd306SrtahbZZCMAAAAAAADQFmhF9mL5/vI6o/B0Kh/yKIYvr7OXB/k7GcXVqs/DWZ6f3duvX2dXRTnK5rbqpvevmOdn96+zqyLLe08vKmd6rqfTPD99sJhICXXcl4+GfOyVHK7l74UUV565lM55nttTrHsOP677FB+lbKp2zimulJ8vqSywklyzJwAAAAAAANAuaEX2fLH8+fLWOtz3fsuKq52L4RAv791vb8bhxyw/vd+11gAAAAAAAAAPvcieL3/8fG0h/nOaZ1nxx67FUPHHR3nLvE3Brv+VZb+dPuxcfQAAAAAAAMABrciezRd//3gBAAAAAAAAAKAJUGQDAAAAAAAAQGJoRfYYBAKBQCAQCAQCNSatyH4HgUAgEAgEAoFAjSm7AIFAIBAIBAKBQEkpm80X4/H4/f394uLi6FwAAAAAAAAAANAQ2d8/XlBkAwAAAAAAAEBCoMgGAAAAAAAAgMRAkQ0AAAAAAAAAibGDInswFUKI0W0zPpfiWYjuuRg1Z9WSibY818Eo4pjrUjxPxcnOrbEXtvqHYwuhshfReC6OzsXJnRBCdHctxjawa6eMhBBCiEli4UdCPN8xQzaRAVKxTeuOlit7AAIfql5JOTcqskdkIr51JeiTu8iEwnErV+NgKgaXSe2bdCLbROusGqPUYCrErrfnOPVTG41r9MyVMGU7WWlTx05a11arw6qk0e26NlKJM8jeB1hySK/FuK/eomiD0VwDyw1GvlZj7Mhul0qRjfwUJtuQubyca/udsZIxXdoo7U6YUjiF8CN7+Z/XzDa1E0tajWpzqylVTO2hmqi+T1vundpu2ooj/HagNs1Vu1mVJRW4ZpHdnegyqWqT7UpARISgk9toO0V23YlIEw2mpV9v6cMGMdeleJ6KZzJjbhGx6ic0Ghts3rm2dU3VMAjr2aqKJRJqqeSeaz8DLDFqhcpBFtla5adGkbJzqBc83YmrkTWFzdYq7tdiMJG8cb9T6yJtlG60JOXus5rum+GJJbVGNVBfqpjaw/jkZ9RAhVZ7p/WO8NqB3DTJqiyhwHSRTR7LuhPzWE9e0w4utXZjlFFky/pp1Wh09nLTFJuKQclNDX1Ni0vxLMSgbB/dVgJIU8qzjmMTkjK45bdNNNJ3ka5bKcVi9p3HqFKuEtVsVMzS5bUzRtl2085/8sLPmN2aK5XRyEaX0ZgbNVt3QxJN06k4UTVaZX8qzEzjqHeivImaB5i7yFYDZi8DLMxfZCbRLHNrulKTzQ4VZZtXg6FbV+aQ+10t6oIjJ0iA4IGqswzhu8Zb5AYWVQqHsCWLbyfohB/o94B1EZoGfVuMEbG2X8xPmQKEJ5cG++lffLZR+/sTS+B2bAe/svpGQogJO4rMTgn37ojaw/GhgR0bAdly094h0iMpjC6tNvu29rhYR5B2YHW3lwmfapoI7LvJvqyO8t5iSCrgsEh3wjiYryFCi2yhHEeMPlIL9YLkVghrSOUbm4ktg1N+wkTWVU1Ikb0+S+lH/MG0iqGRkqPNRtUsjHYkK9v7xpFOO/wp640r++objWl0GK2STTEaoTspiXr3o2oki+yy5eROs6H9uIjHRI0DTN3yiYfRg7NSOwMsxF8VjLeUC4l1wmEsT4RK+cIMhnoyM9FoulufKDxy/AKEDdS0U4VUAkkN+BF1ziEbaZBsrR3OVdMH8DfjM8YpjnURkgYdWwwxBR88oRHFLI2Qe7iozByaWJg8aa8gIuWWydOMJX3d2Skl4d5do/ZwXZoyW2TyYiPUO3p6lJViaOq409y06T0uwhE+jxyRmyZTlSUU2P+4iGOhGpqrcc8+PmvcVfA+8HMzOEtWVN4kMib1Wp2LPp4aweo7UbFFdgh/XcjKEQH3QFWjfsYKGkV5n6wjHXMlM5qz0RNj+r2IqaYliTmFHSGk4qRxvCYKMVeArdbdBFNshZirhQEW5i+HoeTwkbwNtS1PhgqVCgxEyMxEoyuwYyInSICAgZolrXPmmph28uFpz7eFSLbWDrfesdTOIvQrPa6EH+AUzlZxaTBwV+J8Fx5RzNLQrrS8CMg2oYmFyZO24mTwj+wK2/BpoK1qKRtde5CsArbI5MVGeNpX06Mr0uSMxuxb2eOiHRFlB7lpxlZl8QKzRbb6MU1IkT3Qnyi3R5HnDznKyAVebiYY15pauDOgkc0DimBOftJEgWcmzgtC0AdfsgShI97WjhxFeV/bXfRR1V4YUhHGGs3Z6FkD+rZqe1aTxPZIkyLba6Iwc3ltpfGPCa1WB1iIv5yGWuW76rFU0vJcqJSpoMvbKlRmcgojxoyJYiLHL0CKIrtL3kfK/naeJBsprTW2lilq3GQHJXyvU7h1EZsGw4tsznfBEUUujbgi25ttwh3B5EnCO3bKXb2tBKE5iktEtq1qKRtde5BfywuJjUQCR3tHBoZ+/UyEn65CNftW9rhoR0TaQT3DR1VlsQIzRbYSN2w65use9022zY3N4G5uBmcymRpa+DJg1IEpRP6RtW3EupO4OAk7JbuPzoTd1HLK8r69nbsvNRMaLSIMuEhwDl9LEltkK/0JN3lNFGMu9wJZ8Sc+hQxASwMsxF/ut8orsaqI4eppspGsfWvI7PU4U2fUu5AOF4DN6oaQepCHP+ZINpI6VmwNU8Q/kx2a8AOWIb0uYtNgeJEdnvScPI2l4di7HeDWV73Pxyorkd5hUu5IfeTA4VPmLra5sg6nkN1MOwdskWkFjkr7q7P0yZ328xru1K3NvvU9LtxWUdf55qMdsef5MIH5Lz5OqllXART47KzRbj+TLU1wcleGZnl9Qt52O7jRAVG+JrTwZUDjewOkdvKrxCHyGyYaqM8wTWKUKrnJhKI+UcQ26hxI7exRnPfVXXNAPozFx1wTo5GNIV9DUZeBrbstyWBKPyBYvVZa1C/va8Yp+3hMxJsryFZK/LivA/c0wEL8pVrMfmsw1c3CHL3MUFHcZ16nxcvMRaMKM+piIscvQNhAcvmY4SQVvzV/foRt5GKPZGs1Eg9NOkM6POF7nMKvi7g0GFNkk8ETGFHc0pA505EtQzNz3cQinUKuIDbllh+GkKPI7JR87z4KrD2YXxfxbpEpBY7yTqna81TTzpE6zNm3s8fFO8JjB2bTJKuyhAKzj4uMVvfdym2QyqurfDOa/AYMZxHt10VuKyaOXFC7yCa0CMiAA+Ob/ha0rwjw8nMmGulDHErZv8FETD1VosputKKc0I5iZXt/Fb7VQPmn9+nGxkZjG7npyimeJ/QHXtWSs3xR9ZlQEaJobT6jJhvVCzOHiXhzBdlKlUSXn/7ljb0LsDB/cZnkiDn5mK/tUCFTwaSuzHw0HpFGm+hsvZHjFSB4IBED5+amJXcamcSEUpFzjUQ1T7LVQ9r9+BPNNjzhO53iWhdRaTCmyKaDJzCiqPg3bgEabmdRieWIyZPECuJT7ioqBpfUKDI7pdu71XAKqu30Z1rs333ntshUAsd5R75rne01Yaj1Ioy0v9E9Lt4RHjswm+YRVZUlFHjb//Ex+p/RtA/EZ0M7BBnHMR/TNB21j0ZLa+3DttWeBBhpxhqfxgJRn5n6WW3C49sNpD1FYBrZSLbZmoMiJ2pXaj1EgQ9VryYC7+Dfqo/U097e4VI8t+CQoF7udp2N9VgdpNHSKLLpzaMdttqzALNwAIf5HSLVv1WP+9dju2Z7SBgF/pzihrLNhvNkzZTSjtQaZ8b9EvhQ9Wom8A6KbAAAAAAAAAA4bKDIBgAAAAAAAIDEQJENAAAAAAAAAImBIhsAAAAAAAAAEgNFNgAAAAAAAAAkRvb+6xeKbAAAAAAAAABIiGzy3+fxeLxcLi8uLgQIBAKBQCAQCARqTNlsvpA32X/9/B8AAAAAAAAAAA3xf26EKAAqTfLxAAAAAElFTkSuQmCC" alt="" />

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9QAAAAvCAIAAACNCxWUAAAPTUlEQVR4nO1dS28jxxHu/yR4IB03f0NAkB0Ji+S0+Qc85LIkHSwQX7w38eAAgewVtQEWCaAL4Usc2wpWEjeHBRjIBgL4kaW9lkRKMjA5kNPTj+ru6uHM8OHvw3egmtPV1VXV1TXNISWuryeryT/86SO78ezsgsNFxv3uu/998cWXL1789bPP/nl1dbN0O9TBr77+NgMYePOf/wZjckX44HF3/+lffvfBJzv7rZeffv7l+b//+OHBy08/39lv/faDT37d+ejB466r7yrPCwRBEAQ3jGLpGoDN86uvv/3m+x+WXdmuOr75/gej+F5ldv/8twePuw8ed3f2WwYfPO7+6vfdj/7+j6UrCYIgCIIgiu9fIt++fff1N2MwyLdv3y3dWSAIgiAIbhJRfIMgCIIgCIJgQ0TxDYIgCIIgCIINURwAAAAAAAAAANAIxI8KDg4OfgQAAAAAAAAAoB6IyfRO8uDgYNm/MAEAAAAAAAAAGwsU3wAAAAAAAADQEFB8AwAAAAAAAEBDQPENAAAAAAAAAA1hbYrvN093hHj0Mnzhy0dCCMG7diXgV/jlIyF2nr5pWikAAAAAAACgBqxm8f3m6Y5ecL55uiOLU+tNFS8fVVqqeseqRKKmcF6H66V4xXMCAAAAAAAAloX1KL7Z5Wf1xXLVMDRU/nzzdEdQr/VbDwAAAAAAAGB9YRbf9/c/qy0KX3eS/FQ2ef9iejcZvp83bHeGd5NZS/J+Z09tfN1JRHqcCznen/ctpNl9txM50HysF6m8LL/yghjrrr8nu213hpSGKmdyrNdSSNJ97RlrMr2bTF+kQh8xIF+xoRCikCmE2O5094XY7yvWLuw2fZEWb4EgCIIgCILrSrP4vrv/+WZya7OfCpEeKy3DdiLS/u3N5PamvyeS7vnk9uaimwirsb8nO/ZTkXSG6gu672TYTrbbF/lYF91kdo36JzmW1pHSUKUqVr4urjxud4ahsfJZTI5ToSjskW9MzVJYmGpQBgFBEARBEATXk8zi+zgVe321RSuI89KTLjdlX1mhqtKovkatqZTvheRgaUtq6JoCUXyHxrroJvYsgvJ9xffteWdbJNuzw/H8PmTOfmq2gCAIgiAIgmtHXvGtFZq3NxOjSM3PmOlyMy8c9UNuBfUU36SGxqRoCXO1ihmFy/Qqim9ToKYwim8QBEEQBMENoFV8391f30xNnncTsXfkbDlORdI+n16fd5OkeyYvkK/7eyI9PmsnaV9er0szrr8ZtpOkfU6+lf9Jj6V0JDV0TcEY4mZ61k6EHIUcS+vCl69PTfnzrJ2I9Fh2P0pF0h7al4EgCIIgCILrS17xfTNsJ0ItDWct82K6vyfsetSqTZOkKLjVyvIo3Tsyr58epbnwvLtZiweLb1JDlefdJBd7lIrZBWftvXn3/p5Ij71jzQ6nTVF++dbUjLsFKUQRPv/Tul0BQRAEQRAE141m8X17d391PaF48UQ+LJL2r64nV2fypzvS57NrzjpJ0nllv76ePE/zXra02WX69YXwpPPqevI8FUn74kqVTI918SRJnpxZQqSGOl/lj5g8bOcSjuTvl6TPA2MpFydJQg1ByDenpitcjC4eHulyNOuBIAiCIAiCa0mz+J7e3v10dbNyfNV+T6TPl66GR72k/aou+f2HInnyatlzBEEQBEEQBBemVXxP7979dL2C/NeTRIj042WrofLjh/Kcuj7Fjn4jxHtPzpY+WRAEQRAEQXBxmsX3ZHr747srEARBEARBEAQrJ4pvEARBEARBEGyIZvE9BAAAAAAAAACgHpjF9z0AAAAAAAAAAPVAHAAAAAAAAAAA0AjEZHo7md4Oh8P7+/uDg4OtZxkIgiAIgiAIgnVQzB79RvENgiAIgiAIgnUTxTcIgiAIgiAINkQU3yAIgiAIgiDYEJdTfPfGWZZlg5PF5Bxml1nWepYNFhe1IgM1PNbGTMQz1mF2Oc52l26NtbDVL5wNhMpaROOzbOtZtnuaZVnWWrYaTXDZThlkWZZl2ahi5QdZdnnq6FJHBqhKbLXuWPHJboDCmzqv+hVetPgekAn6xJe4d08jE41LWr5Ke+Osd1ip3SsdyDbRPNvGTKo3zrJlb9tx06/aaK7GwFgVpnKvKG3o2EHL2mp2EysxOJnXTCpcBln7AKuc0msx7iu3KFbBaL6O+Q4hX6sxtmW3y0mRje4hTLGcsYKSS/vdYSVjuGqjtDVylMhVKD+wl/+zktmmdGKpdkalpZXUKqb2UE1U3qcr7p3SbmrEEWE7UJvmrN2syupXuHzx3RrpuqrSyXYlUCJC0ytt0EzxXXYg0kS9ce7vE/omhBjrMLscZ5dkJm2QsdOv0GjOYAuO1dSx1oJBWM5WRSyRVEso/1jrGWAVs1SobGTxrVWEahQpO4p6INQa+RqdprDFWkX/XA1HJNfud2pdVBultZaqrnOuRfdNfmKpekYlWF6rmNrD+KRosMAUVto7K++IoB3ITZOsyupW2Fl8k7dxrZF5DEAe6/YOtXajl1F8y7pq1mhcHJSmTXic9XJp6pLQZnGYXWZZL28fnBQKSBPLeyPP5iR18Otvm2ig7y4t/6QUi9lnJINicoWqZqNilpZ7dkYv227a/aI8IDRGt8aqymhko89ojhM4e+6GJtpMx9muOqPZrkCFmWkc9QzVbaLFA8xffKsBs5YBxvMXmUk0y5yYrtR0s0NF2f7VYGiV1ZlzHqxFHTtyWAqwO6rOMpRvGW+RG1tUicwRSxblXtIJn+l3xrrgpsHQFmNErO0X81MphvLk0nB+WhifbdTrw4mFuR3bwa+svkGWZSNnLzI7Vbh3R9Qeng8Z7NhgZMu6vUOkR1IZXVtt9Kb2uFhHkHZwzt1eJu5UU7nCjJPvw+LWP1gkyYl5Bm6NHI531xbc4jtTbl+Ma+Qs1AOVkyyzuhQ+s4XYOnj1J0xkHe1wiu/5vZd+JNAbF7E1UHK32aiaxTE7UpTtfeMWULtZVNahqxwsbzRHo8dohW6K0Yi5k5qoZ0XqjGTxnbfsnmo2tB87CZho4QBTSwHiYXd2tlrNAOP4q6DxlnKAMU84DssToZK/MIOhnM6OaDTdrQ/Ej5ywAryO2uxUJZVAUgN+QN3/kI00SbHWzuer9RnyzfiMcYpnXXDSoGeLIYZwBw83ohxLg3NuF5WZuYnFkSftFUSk3Dx5mrGkrzs7pVS4d5eoPXyHrI4tsvJig+sdPT3KCpKbOk41N9W9x0U4IuSRLXLTdFRldSvMeuzEs4CNAdT14Hw81zjbcPsmLM2QLEVR+ZTIpNRrdSz6dtYI4tAdmLP45sjXlSwcwTg3Khr1ezJWL8r7ZH3pGasyo3kbAzGmn6OY07Q0MYewI4ScOGmcoIk45mLYan5Z5ijCOOZawQDj+ctjKNl9IE9PbcuToUKlAoMROjui0RfYMZHDUoDRUbOkdf85h6OdfDg78C0lUqy18813MvXijPuVIV/CZzjFZau4NMjclVy+40eUY2loR11BMrINN7E48qQ9cTL4B3blbfiUaatSk42uPUhRjC2y8mKDn/bV9OiLNDmiMXoje1y0I6LsIDfN2KqsIoV9xbf6cQ+n+O7pT7LbvcjyX/YyckRQmkmHy81Z+DOjkeUZxbFLf9JEzHsslxeyjL5RJksTeiXYsyN7Ud7Xdh29V7FHcirFWKN5Gwmquunbre1ZTRPbI4sU30ET8cwVtJUmPya0VjrAOP7yGmqWB4vHXknLu0IlTwUtt624OpNDGDFmDBQTOWEFqii+W+T5pbzezpNkIzVrTaxlihIn36yEH3SKa13EpkF+8e3yHTuiyKURV3wHsw3fEY48SXjHTrmzt5UgNHu5EpFtq1KTja49yG/XcWKjIoWjvSMDQz+uJsJPn0IxeiN7XLQjIu2g3ttHVWWVKOwuvpV4cqZpdz3kP/m2pTkzu1+aIZlMssYsQpkx6gaLo//A2k5i3UwctPDuqv232oTd1DLL8r69zfsPQSs0WkQYuCLB232uSWzxrVxPuCloohhz+RfITD7xaSaDKxpgHH/538qP0IrixlVnk41kTVxC56DHHfVHuQNsvgLOrG4oqQc5/zFKspGcYyHWMEX8M9/chM9YhvS6iE2D/OKbn/S8Mo2l4dm7PXStr3KfpxVWIr3jSLkD9dEFj08dZ7eLT9bjFPIy086MLbJahaPS/uwee/dU+7kPf+rWRm98j+PbKur433xEJPY+fwGFvV+4HBXazAKL+Wyu0W4/8y1Ns3uah2x+3EKejnuk0YGSvyZmEcqMxvcVyNnJrzZz9DdM1FOfkRrFTCqXJhON+sSSs1GXQM7O7uXyvrqb9siHvdyxuIjRyEbO11/U5WHP3dakN6YfQCxeKy3qjwloxsmvCZjIbS6WrZT48R8frmmAcfylWsx+qzfWzeK4JTNDRXGfefwWr7MrGlWaURcTOWEFeB3J5WOGk5z4iflzKM5GV+yRYq1G4qFMb0jzE37AKe51EZcGY4pvMniYEeVaGjJnerIlNzOXTSzSKeQKcqbc/MMTsheZnSrfu7eYtYfj106CW2SVCkd5J5/a5VibnSd1mKM3s8fFOyJgB8emSVZldSvse+xkMDs3V06PVBEt5Zva5DdvXANrv3ZyUgjx5IjSxTcxC0Zm7Bm/PGBR+2qCW3+XiQZ6F8+k7N+KIoYeK9FmN1rRT8yOEmV7fxbWRUf5Z/DpyYWN5mx0DZcPcTmiPzgrlqLli+KaERUhyqzNZ+Bko3rA5jGR21wsW6ma6PrTvwSydgHG85crk2w57ojM13aokKlgVFZndzRukUYb6WKDkRNUgN2RiIFn5mYmdyCZxDKlUnc1ElU+KVYPaf9jVLRYfsL3OsW3LqLSYEzxTQcPM6Ko+DdOBxbczqISy5YjTxIryJ1yZ1HRO6R6kdmpur1bDSdWzac/G2P/br1ri6xK4TjvyHete35NGWq9ZEbar3WPi3dEwA6OTXOLqsrqVngJ/+Ey+p/srB6Jz5iWSDK+Yz7uWbTXOhqtWmtvtq3WJMBIM5b4VBeM+uw1LKoOjzcbSGtKZhqpJds05qDIgVYrtW6iwps6r8oVXs6/lx+od4drx8PscgVuHtTD4Ja3sZyojTRaNROpe1NZDVutWYBZ3ICb/CWyqn8vH/cv1ZYtdpM4YP7sY03ZpuY8WTKlrEZqjTPjeim8qfOqQeHlFN8gCIIgCIIg+Askim8QBEEQBEEQbIgovkEQBEEQBEGwIf4fnh+nRKkkvQYAAAAASUVORK5CYII=" alt="" />