{"id":129,"date":"2023-06-05T12:31:13","date_gmt":"2023-06-05T04:31:13","guid":{"rendered":"http:\/\/pro369.com\/sale\/?p=129"},"modified":"2019-05-14T08:22:07","modified_gmt":"2019-07-14T08:22:07","slug":"mysql-41%e4%b8%ad%e6%96%87%e4%ba%82%e7%a2%bc%e7%9a%84%e8%99%95%e7%90%86%e8%88%87%e8%a7%a3%e6%b1%ba%e4%b9%8b%e9%81%93","status":"publish","type":"post","link":"https:\/\/por.tw\/sale\/mysql-41%e4%b8%ad%e6%96%87%e4%ba%82%e7%a2%bc%e7%9a%84%e8%99%95%e7%90%86%e8%88%87%e8%a7%a3%e6%b1%ba%e4%b9%8b%e9%81%93\/","title":{"rendered":"Mysql 4.1\u4e2d\u6587\u4e82\u78bc\u7684\u8655\u7406\u8207\u89e3\u6c7a\u4e4b\u9053"},"content":{"rendered":"<p><strong><font size=\"3\" color=\"#ff00ff\">Mysql 4.1\u4e2d\u6587\u4e82\u78bc\u7684\u8655\u7406\u8207\u89e3\u6c7a\u4e4b\u9053<\/font><\/strong><\/p>\n<p><strong>\u8981\u8b93 Mysql 4.1\u6b63\u78ba\u986f\u793a\u4e2d\u6587\u6700\u7c21\u55ae\u7684\u65b9\u6cd5\u5c31\u662f\u5168\u7a0b\u4f7f\u7528 utf8\uff0c\u5f9e\u7db2\u9801\u5230\u9023\u7dda\u5230\u8cc7\u6599\u5eab\u7b49\uff0c\u800cmy.ini\u7684\u8a2d\u5b9a\u5982\u4e0b\uff1a<\/strong><\/p>\n<p>[mysqld]<br \/> default-character-set=utf8<\/p>\n<p>#settings for clients (connection, results, clients)<br \/> [mysql]<br \/> default-character-set=utf8<\/p>\n<p>\u5176\u4e2d [mysqld] \u662f\u8a2d\u5b9a mysql\u555f\u52d5\u6642\u8981\u63a1\u7528\u7684\u8a9e\u7cfb\uff0c\u800c[mysql]\u5247\u662f\u901a\u77e5\u5916\u4f86\u7684\u9023\u7ddaclient(\u4f8b\u5982php\u9801\u9762\u6216 flash \u7a0b\u5f0f)\u8981\u4f7f\u7528\u4f55\u7a2e\u8a9e\u7cfb\u8a2d\u5b9a\u3002<br \/> \u9019\u500b\u8a2d\u5b9a\u65b9\u6cd5\u5c0d\u4e00\u822c\u7684\u958b\u767c\u5de5\u4f5c\u975e\u5e38\u9069\u7528\uff0c\u4f46\u6709\u500b\u5c0f\u7f3a\u9ede\uff0c\u5c31\u662f\u7576\u4f7f\u7528\u4e00\u4e9bopen source php\u7a0b\u5f0f\u6642(\u5c24\u5176\u662f\u82f1\u6587\u5beb\u7684\u7a0b\u5f0f)\uff0c\u5982\u679c\u9019\u4e9b\u7a0b\u5f0f\u8a9e\u6cd5\u9084\u505c\u7559\u5728mysql 4.0\u6642\u4ee3\uff0c\u90a3\u4e0a\u9762\u7684\u8a2d\u5b9a\u5c31\u6703\u5c0e\u81f4\u4e2d\u6587\u986f\u793a\u8b8a\u7684\u602a\u602a\u7684\uff0c\u6700\u660e\u986f\u7684\u60c5\u6cc1\u5c31\u662f\u5927\u90e8\u4efd\u4e2d\u6587\u90fd\u986f\u793a\u7684\u51fa\u4f86\uff0c\u4f46\u5c11\u90e8\u4efd\u6703\u8b8a\u6210 \u65b9\u584a\u578b+\u554f\u865f \u7684\u4e82\u78bc\uff0c\u4f8b\u5982\u300c\u88cf\u300d\u9019\u500b\u5b57\u5e7e\u4e4e\u662f\u7a69\u6b7b\u3002<br \/> \u9019\u7a2e\u60c5\u6cc1\u5728 drupal \u8207 gregarius(\u4e00\u500bphp rss reader) \u4e0a\u898b\u904e\uff0c\u7d93\u904e\u4e00\u756adebug\u624d\u767c\u73fe\u4e86\u4e0a\u8ff0\u539f\u56e0\uff0c\u5f8c\u4f86\u7d42\u65bc\u627e\u5230\u89e3\u6c7a\u65b9\u6cd5\u3002<\/p>\n<p><strong>\u6700\u7c21\u55ae\u7684\u65b9\u5f0f\u5c31\u662f\u4e0d\u8981\u4e0b\u9762\u9019\u6bb5\uff1a<\/strong><\/p>\n<p>[mysqld]<br \/> default-character-set=utf8<\/p>\n<p>\u62ff\u6389\u9019\u6bb5\u5f8c\u6703\u8b93mysql \u555f\u52d5\u6642\u505c\u7559\u5728\u9810\u8a2d\u7684latin-1\u8a9e\u7cfb\uff0c\u9019\u6a23\u6703\u8b93\u5927\u90e8\u4efd\u82f1\u6587\u7a0b\u5f0f\u90fd\u5f88\u5feb\u6a02\uff0c\u800c\u8981\u4f7f\u7528utf8\u4e2d\u6587\u7684\u4eba\uff0c\u53ea\u8981\u8a18\u5f97\u5efa\u8cc7\u6599\u5eab\u6642\u5c07\u5b83\u8a2d\u6210utf8\uff0c\u7136\u5f8c\u4fdd\u7559 [mysql] \u9019\u6bb5\u8a2d\u5b9a\uff0c\u8b93\u4e2d\u6587\u7a0b\u5f0f\u6b63\u78ba\u7684\u4f7f\u7528utf8\u8207\u5b83\u6e9d\u901a\u5373\u53ef\u3002<br \/> <strong><font color=\"#ff00ff\">\u7d93\u904e\u6e2c\u8a66\uff1a\u9019\u6a23\u6539\u826f\u5f8c\u7684\u8a2d\u5b9a\uff0c\u4f7f\u7528\u5e38\u898b\u7684\u82f1\u6587php\u8edf\u9ad4(\u5982wordpress, drupal, OSCommerce, gregarius)\u90fd\u6c92\u554f\u984c\uff0c\u800c\u958b\u767c\u8981\u7528\u7684 flash &#8211; amfphp &#8211; php &#8211; mysql \u9ec3\u91d1\u7d44\u5408\u4e5f\u540c\u6a23ok\u3002<\/font><\/strong><\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mysql 4.1\u4e2d\u6587\u4e82\u78bc\u7684\u8655\u7406\u8207\u89e3\u6c7a\u4e4b\u9053 \u8981\u8b93 Mysql 4.1\u6b63\u78ba\u986f\u793a\u4e2d\u6587\u6700\u7c21\u55ae\u7684\u65b9\u6cd5\u5c31\u662f\u5168\u7a0b\u4f7f\u7528 ut [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":610,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[22],"tags":[53,55],"_links":{"self":[{"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/posts\/129"}],"collection":[{"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/comments?post=129"}],"version-history":[{"count":0,"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/posts\/129\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/media\/610"}],"wp:attachment":[{"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/media?parent=129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/categories?post=129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/por.tw\/sale\/wp-json\/wp\/v2\/tags?post=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}