{"id":416,"date":"2018-11-14T11:52:00","date_gmt":"2018-11-14T02:52:00","guid":{"rendered":"http:\/\/www.fatware.jp\/?page_id=416"},"modified":"2019-01-07T18:09:18","modified_gmt":"2019-01-07T09:09:18","slug":"mariadb%e3%81%a7%e7%b5%b5%e6%96%87%e5%ad%97%e4%bf%9d%e5%ad%98","status":"publish","type":"page","link":"https:\/\/www.fatware.jp\/?page_id=416","title":{"rendered":"[SQL]MariaDB\u3067\u7d75\u6587\u5b57\u4fdd\u5b58"},"content":{"rendered":"\n<p>Python3\u3000MysqlDB\u304b\u3089MariaDB\u306b\u7d75\u6587\u5b57\u3092\u4fdd\u5b58\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u201dWarning: (1366, &#8220;Incorrect string value: &#8216;\\xF0\\x9F\\x98\\x8A\\xF0\\x9F\u2026&#8217; for column &#8216;lunch&#8217; at row 1&#8221;)&#8221;\u306e\u3088\u3046\u306a\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u3001\u4fdd\u5b58\u3067\u304d\u306a\u304b\u3063\u305f\u3002\u7d4c\u7def\u3092\u8abf\u3079\u308b\u3068\u3001\u73fe\u5728\u306eUTF-8\u306f\uff14byte\u5229\u7528\u3057\u3066\u3044\u308b\u304c\u3001MariaDB\u306f\u6b74\u53f2\u7684\u7d4c\u7def\u306b\u3088\u308a3byte\u306eUTF-8\u307e\u3067\u3057\u304b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u3002\u7d75\u6587\u5b57\u3067\u62e1\u5f35\u3055\u308c\u305f\u90e8\u5206\u304c4byte\u5229\u7528\u3059\u308b\u3068\u3044\u3046\u3053\u3068\u306e\u3088\u3046\u3060\u3002<br><br>\u3053\u306e\u5834\u5408\u4ee5\u4e0b\u306e\u5bfe\u5fdc\u304c\u5fc5\u8981\u3068\u306a\u308b\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MariaDB\u306e\u8a2d\u5b9a<\/li><li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306echarcterset\u66f4\u65b0<\/li><li>Python3 MysqlDB\u306echarcterset\u5909\u66f4<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">MariaDB\u306e\u8a2d\u5b9a<\/h2>\n\n\n\n<p>\/etc\/my.conf\u307e\u305f\u306f\u3001\u5404\u9805\u76ee\u3092\/etc\/my.conf.d\/[server.conf|client.conf]\u306b\u5206\u3051\u3066\u8a18\u8ff0\u3059\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[client]<br>default-character-set = utf8mb4<br>[mysql]<br>default-character-set = utf8mb4<br>[mysqld]<br>character-set-client-handshake = FALSE<br>character-set-server = utf8mb4<br>collation-server = utf8mb4_unicode_ci<\/pre>\n\n\n\n<p>\u8a2d\u5b9a\u5f8cmariadb\u3092\u518d\u8d77\u52d5\u3059\u308c\u3070\u8a2d\u5b9a\u5b8c\u4e86\u3067\u3059\u3002\u518d\u8d77\u52d5\u5f8c\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308c\u3070\u8a2d\u5b9a\u306f\u6210\u529f\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; SHOW VARIABLES WHERE Variable_name LIKE 'character\\_set\\_%' OR Variable_name LIKE 'collation%';<br>+--------------------------+--------------------+<br>| Variable_name            | Value              |<br>+--------------------------+--------------------+<br>| character_set_client     | utf8mb4            |<br>| character_set_connection | utf8mb4            |<br>| character_set_database   | utf8mb4            |<br>| character_set_filesystem | binary             |<br>| character_set_results    | utf8mb4            |<br>| character_set_server     | utf8mb4            |<br>| character_set_system     | utf8               |<br>| collation_connection     | utf8mb4_unicode_ci |<br>| collation_database       | utf8mb4_unicode_ci |<br>| collation_server         | utf8mb4_unicode_ci |<br>+--------------------------+--------------------+<br>10 rows in set (0.00 sec)<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Charset\u306e\u5909\u66f4<\/h2>\n\n\n\n<p>\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5404\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30fb\u30c6\u30fc\u30d6\u30eb\u7b49\u306b\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u4f8b\u306eSQL\u5206\u306fDB\u540d\u3084\u30c6\u30fc\u30d6\u30eb\u540d\u304c\u30b5\u30f3\u30d7\u30eb\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<strong><em>\u7279\u306b\u30ab\u30e9\u30e0\u306e\u5834\u5408\u306b\u306f\u30ab\u30e9\u30e0\u540d\u304c\u5909\u66f4\u3055\u308c\u3066\u3057\u307e\u3046\u306e\u3067\u3001\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/em><\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># \u5404DB\u3067\u884c\u3046:<br>ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;<br><br># \u5404\u30c6\u30fc\u30d6\u30eb\uff08\u30c6\u30fc\u30d6\u30eb\u306bcharaset\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u305f\u3089\uff09:<br>ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;<br><br># \u5404\u30ab\u30e9\u30e0\uff08\u8a2d\u5b9a\u3057\u3066\u3044\u305f\u3089\uff09:<br>ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;<\/pre>\n\n\n\n<p><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pytho3 MysqlDB\u306e\u8a2d\u5b9a\u5909\u66f4<\/h2>\n\n\n\n<p>connect\u6642\u306bcharset\u3092utf8\u3068\u3057\u3066\u3044\u305f\u3082\u306e\u3092\u3001utf8mb4\u306b\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">        self.db = MySQLdb.connect(\n            host=Mconfig.strDBhost,\n            db=self.strDBname,\n            user=self.strDBuser,\n            passwd=self.strDBpass,\n            charset=\"utf8mb4\")<\/pre>\n\n\n\n<p>\u4ee5\u4e0a\u3067\u5b8c\u4e86\u3067\u3059\u3002\u7d75\u6587\u5b57\u304c\u4fdd\u5b58\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Python3\u3000MysqlDB\u304b\u3089MariaDB\u306b\u7d75\u6587\u5b57\u3092\u4fdd\u5b58\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u201dW <a href=\"https:\/\/www.fatware.jp\/?page_id=416\" class=\"read-more\">\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":363,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-416","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=416"}],"version-history":[{"count":4,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages\/416\/revisions"}],"predecessor-version":[{"id":422,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages\/416\/revisions\/422"}],"up":[{"embeddable":true,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages\/363"}],"wp:attachment":[{"href":"https:\/\/www.fatware.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}