{"id":15497,"date":"2015-07-11T23:59:01","date_gmt":"2015-07-11T14:59:01","guid":{"rendered":"http:\/\/oichinote.com\/plus\/?p=15497"},"modified":"2015-07-12T00:15:25","modified_gmt":"2015-07-11T15:15:25","slug":"charset-at-column-in-table-of-mysql-database","status":"publish","type":"post","link":"https:\/\/oichinote.com\/plus\/2015\/07\/charset-at-column-in-table-of-mysql-database.html","title":{"rendered":"WordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u6539\u9020\u3057\u3066\u3044\u3066MySQL\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306b\u306f\u307e\u308b"},"content":{"rendered":"<p>\u65e5\u672c\u8a9e\u5316\u3055\u308c\u3066\u3044\u306a\u3044\u3001WordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u3001\u65e5\u672c\u8a9e\u5316\u3057\u3066\u4f7f\u304a\u3046\u3068\u3057\u3066\u3044\u307e\u3059\u3002\u4eca\u56de\u3001MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a\u304c\u3001utf8\u3067\u306f\u306a\u304flatin1\u306b\u306a\u3063\u3066\u3044\u3066\u3001\u304b\u306a\u308a\u306f\u307e\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>VCCW\u74b0\u5883\u3092\u4f7f\u3063\u3066\u4f5c\u696d\u3067\u304d\u308b\u306e\u3067\u3001\u3068\u3066\u3082\u697d\u3067\u3059\u3002<\/p>\n<ul>\n<li><a href=\"https:\/\/oichinote.com\/plus\/2015\/06\/developping-env-with-vccw.html\" rel=\"_RAclick\">VCCW\u3067WordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u958b\u767a\u74b0\u5883\u3092\u69cb\u7bc9 : \u30d7\u30e9\u30b9\u03b1\u7a7a\u9593<\/a> <em>(2015\u5e746\u670817\u65e5)<\/em><\/li>\n<\/ul>\n<p>\u56fd\u969b\u5316\u306b\u304d\u3061\u3093\u3068\u5bfe\u5fdc\u3055\u308c\u305f\u30d7\u30e9\u30b0\u30a4\u30f3\u3060\u3068\u3001pot\u30d5\u30a1\u30a4\u30eb\u3092\u5143\u306bpo\/mo\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308b\u3060\u3051\u306a\u306e\u3067\u3001\u7c21\u5358\u3067\u3059\u3002\u3068\u3053\u308d\u304c\u3053\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u306f\u3001<br \/>\npot\u30d5\u30a1\u30a4\u30eb\u3082\u7121\u3044\u3057\u3001\u56fd\u969b\u5316\u306e\u305f\u3081\u306e\u6587\u5b57\u5217\u306e\u5207\u308a\u51fa\u3057\u3082\u4e2d\u9014\u534a\u7aef\u3067\u3059\u3002\u304b\u306a\u308a\u4fee\u6b63\u3057\u307e\u3057\u305f\u3002pot\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308b\u306e\u306f\u3001\u6b21\u306e\u65b9\u6cd5\u3067\u3067\u304d\u307e\u3059\u3002<\/p>\n<ul>\n<li><a href=\"https:\/\/oichinote.com\/plus\/2014\/06\/localize-with-gettext-and-poedit.html\" rel=\"_RAclick\">WordPress\u306e\u30c6\u30fc\u30de\u3092xgettext\u3068Poedit\u3067\u65e5\u672c\u8a9e\u5316[\u8ffd\u8a18\u3042\u308a] : \u30d7\u30e9\u30b9\u03b1\u7a7a\u9593<\/a> <em>(2014\u5e746\u67085\u65e5)<\/em><\/li>\n<\/ul>\n<p>VCCW\u74b0\u5883\u5185\u3067\u306f\u3001xgettext\u304c\u3042\u3089\u304b\u3058\u3081\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u7c21\u5358\u3067\u3059\u3002<\/p>\n<pre>\r\n[vagrant@vccw ~]$ cd \/var\/www\/wordpress\/wp-content\/plugins\/pluginname\/\r\n[vagrant@vccw ~]$ xgettext --language=php --keyword=__ --keyword=_e --keyword=_n:1,2 --keyword=_x -o languages\/pluginname.pot *.php *\/*.php\r\n<\/pre>\n<p>\u3053\u3046\u3084\u3063\u3066\u4f5c\u6210\u3057\u305f\u3001\u65e5\u672c\u8a9e\u5316\u306e\u305f\u3081\u306e\u30ed\u30fc\u30ab\u30e9\u30a4\u30ba\u30d5\u30a1\u30a4\u30eb(po\/mo)\u3092\u8aad\u307f\u8fbc\u3080\u305f\u3081\u306e\u5b9a\u756a\u306f\u3001\u6b21\u306e\u901a\u308a\u3067\u3059\u3002\u6700\u521d\u3053\u306e\u8a18\u8ff0\u3092\u3069\u3053\u306b\u5165\u308c\u308c\u3070\u826f\u3044\u304b\u3067\u3001\u304b\u306a\u308a\u60a9\u307f\u307e\u3057\u305f\u3002\u8a66\u884c\u932f\u8aa4\u306e\u4e0a\u3001\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u5148\u982d\u306b\u5165\u308c\u308b\u3060\u3051\u3067\u3057\u305f\u3002\u5f53\u305f\u308a\u524d\u3067\u3059\u306d\u3002<\/p>\n<pre class=\"hljs\"><code class=\"php\">\t$path = dirname(plugin_basename( __FILE__ )) . &#039;\/languages&#039;;\r\n\tload_plugin_textdomain( &#039;pluginname&#039;, false, $path);\r\n<\/code><\/pre>\n<p>\u3053\u306e\u3084\u308a\u65b9\u306f\u3001\u79c1\u3082\u6301\u3063\u3066\u3044\u308b\u6b21\u306e\u672c\u306b\u8f09\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n[amazonjs asin=\"B00M939Y0I\" locale=\"JP\"]\n<p>\u3053\u306e\u8a2d\u5b9a\u306e\u672b\u3001\u65e5\u672c\u8a9e\u5316\u306e\u9053\u7b4b\u304c\u898b\u3048\u307e\u3057\u305f\u3002<\/p>\n<p>\u3053\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u3067\u3001Web\u304b\u3089\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u30ad\u30e3\u30c3\u30b7\u30e5\u3057\u3066\u304a\u304f\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3059\u3002\u30ad\u30e3\u30c3\u30b7\u30e5\u3055\u308c\u3066\u3044\u7121\u3044\u72b6\u614b\u3067\u306f\u8868\u793a\u304c\u6587\u5b57\u5316\u3051\u3057\u306a\u3044\u306e\u3067\u3059\u304c\u3001\u30ad\u30e3\u30c3\u30b7\u30e5\u3055\u308c\u305f2\u56de\u76ee\u4ee5\u964d\u306e\u30a2\u30af\u30bb\u30b9\u3067\u306f\u3001\u6587\u5b57\u5316\u3051\u3057\u307e\u3059\u3002<\/p>\n<p>\u30d7\u30e9\u30b0\u30a4\u30f3\u5185\u90e8\u3067\u3001var_dump()\u3057\u3066\u3001\u3069\u3053\u3067\u6587\u5b57\u5316\u3051\u3059\u308b\u304b\u3092\u63a2\u3057\u307e\u3057\u305f\u3002\u305d\u306e\u7d50\u679c\u3001\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u3001MySQL\u306b\u4fdd\u5b58\u3059\u308b\u3068\u3053\u308d\u304c\u602a\u3057\u3044\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u5fc5\u6b7b\u306b\u691c\u7d22\u3057\u3066\u3001\u6b21\u306e\u8a18\u4e8b\u304c\u30d2\u30f3\u30c8\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<ul>\n<li><a href=\"http:\/\/ja.stackoverflow.com\/questions\/4482\/mysql5-1%E3%81%A7%E6%96%87%E5%AD%97%E3%82%B3%E3%83%BC%E3%83%89%E3%82%92utf8%E3%81%AB%E8%A8%AD%E5%AE%9A%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95\" target=\"_blank\">mysql &#8211; mysql5.1\u3067\u6587\u5b57\u30b3\u30fc\u30c9\u3092utf8\u306b\u8a2d\u5b9a\u3059\u308b\u65b9\u6cd5 &#8211; \u30b9\u30bf\u30c3\u30af\u30fb\u30aa\u30fc\u30d0\u30fc\u30d5\u30ed\u30fc<\/a><\/li>\n<\/ul>\n<p>VCCW\u306eWordPress\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u3001\u6b21\u306e\u8a2d\u5b9a\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre>\r\n% vagrant ssh\r\nLast login: Sat Jul 11 08:16:16 2015 from 10.0.2.2\r\n                   ___           ___           ___\r\n      ___         \/  \/\\         \/  \/\\         \/__\/\\\r\n     \/__\/\\       \/  \/:\/        \/  \/:\/        _\\_ \\:\\\r\n     \\  \\:\\     \/  \/:\/        \/  \/:\/        \/__\/\\ \\:\\\r\n      \\  \\:\\   \/  \/:\/  ___   \/  \/:\/  ___   _\\_ \\:\\ \\:\\\r\n  ___  \\__\\:\\ \/__\/:\/  \/  \/\\ \/__\/:\/  \/  \/\\ \/__\/\\ \\:\\ \\:\\\r\n \/__\/\\ |  |:| \\  \\:\\ \/  \/:\/ \\  \\:\\ \/  \/:\/ \\  \\:\\ \\:\\\/:\/\r\n \\  \\:\\|  |:|  \\  \\:\\  \/:\/   \\  \\:\\  \/:\/   \\  \\:\\ \\::\/\r\n  \\  \\:\\__|:|   \\  \\:\\\/:\/     \\  \\:\\\/:\/     \\  \\:\\\/:\/\r\n   \\__\\::::\/     \\  \\::\/       \\  \\::\/       \\  \\::\/\r\n       ~~~~       \\__\\\/         \\__\\\/         \\__\\\/\r\n\r\nhttp:\/\/vccw.cc\/\r\n\r\nInitial code by Takayuki Miyauchi.\r\nhttps:\/\/github.com\/miya0001\r\n[vagrant@vccw ~]$ egrep 'DB_' \/var\/www\/wordpress\/wp-config.php \r\ndefine('DB_NAME', 'wordpress');\r\ndefine('DB_USER', 'wordpress');\r\ndefine('DB_PASSWORD', 'wordpress');\r\ndefine('DB_HOST', 'localhost');\r\ndefine('DB_CHARSET', 'utf8');\r\ndefine('DB_COLLATE', '');\r\n<\/pre>\n<p>\u76f4\u63a5\u3001MySQL\u306b\u3064\u306a\u3044\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<pre>\r\n[vagrant@vccw wordpress]$ mysql -u wordpress -p \r\nEnter password: wordpress\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 604\r\nServer version: 5.5.43-log MySQL Community Server (GPL) by Remi\r\n\r\nCopyright (c) 2000, 2015, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| test               |\r\n| wordpress          |\r\n+--------------------+\r\n3 rows in set (0.00 sec)\r\n\r\nmysql> use wordpress\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\n<\/pre>\n<p>\u3061\u3083\u3093\u3068&#8221;wordpress&#8221;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u3042\u308a\u307e\u3057\u305f\u3002\u76f4\u63a5\u3001\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u633f\u5165\u3057\u307e\u3059\u3002\u307e\u305a\u306f\u3001ASCII\u3060\u3051\u306e\u30c7\u30fc\u30bf\u3092\u633f\u5165\u3057\u307e\u3059\u3002<\/p>\n<pre>\r\nmysql> insert into wp_pluginname (URL, body, updated) values (\"AAA\", \"AAA\", NOW());\r\nQuery OK, 1 row affected (0.01 sec)\r\n\r\nmysql> select * from wp_pluginname;\r\n+----------+----------------------------------------+---------------------+--------+\r\n| Cache_id | URL                                    | updated             | body   |\r\n+----------+----------------------------------------+---------------------+--------+\r\n|       10 | AAA                                    | 2015-07-11 08:23:34 | AAA    |\r\n+----------+----------------------------------------+---------------------+--------+\r\n1 rows in set (0.00 sec)\r\n\r\n<\/pre>\n<p>\u554f\u984c\u306a\u304f\u3001\u633f\u5165\u3067\u304d\u307e\u3057\u305f\u3002\u6b21\u306f\u3001\u65e5\u672c\u8a9e\u3092\u542b\u3093\u3060\u30c7\u30fc\u30bf\u3092\u633f\u5165\u3057\u307e\u3059\u3002<\/p>\n<pre>\r\nmysql> insert into wp_pluginname (URL, body, updated) values (\"BBB\", \"BBB\u3044\u3044\u3044\", NOW());\r\nQuery OK, 1 row affected, 1 warning (0.00 sec)\r\n\r\nmysql> select * from wp_pluginname;\r\n+----------+----------------------------------------+---------------------+--------+\r\n| Cache_id | URL                                    | updated             | body   |\r\n+----------+----------------------------------------+---------------------+--------+\r\n|       10 | AAA                                    | 2015-07-11 08:23:34 | AAA    |\r\n|       11 | BBB                                    | 2015-07-11 08:24:09 | BBB??? |\r\n+----------+----------------------------------------+---------------------+--------+\r\n2 rows in set (0.00 sec)\r\n\r\n<\/pre>\n<p>\u3052\u3052\u3063! \u5316\u3051\u3066\u308b\u3002WordPress\u306e\u554f\u984c\u3067\u306f\u306a\u304f\u3001MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u4f55\u304b\u304a\u304b\u3057\u3044\u3067\u3059\u3002\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u8868\u793a\u3055\u305b\u3066\u307f\u307e\u3059\u3002<\/p>\n<pre>\r\nmysql> show variables like 'char%';\r\n+--------------------------+----------------------------+\r\n| Variable_name            | Value                      |\r\n+--------------------------+----------------------------+\r\n| character_set_client     | utf8                       |\r\n| character_set_connection | utf8                       |\r\n| character_set_database   | utf8                       |\r\n| character_set_filesystem | binary                     |\r\n| character_set_results    | utf8                       |\r\n| character_set_server     | utf8                       |\r\n| character_set_system     | utf8                       |\r\n| character_sets_dir       | \/usr\/share\/mysql\/charsets\/ |\r\n+--------------------------+----------------------------+\r\n8 rows in set (0.01 sec)\r\n\r\nmysql> show create table wp_pluginname;\r\n+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table          | Create Table                                                                                                                                                                                                                                                                                                                    |\r\n+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| wp_pluginname | CREATE TABLE `wp_pluginname` (\r\n  `Cache_id` int(10) NOT NULL AUTO_INCREMENT,\r\n  `URL` text NOT NULL,\r\n  `updated` datetime DEFAULT NULL,\r\n  `body` longtext CHARACTER SET latin1,\r\n  PRIMARY KEY (`Cache_id`),\r\n  UNIQUE KEY `URL` (`URL`(255)),\r\n  KEY `Updated` (`updated`)\r\n) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 |\r\n+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (0.00 sec)\r\n\r\n<\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u305d\u306e\u3082\u306e\u306futf8\u306b\u306a\u3063\u3066\u3044\u308b\u3051\u3069\u3001wp_pluginname\u3068\u8a00\u3046\u30c6\u30fc\u30d6\u30eb\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u304c&#8221;latin1&#8243;\u306b\u306a\u3063\u3066\u3044\u308b! \u3053\u308c\u304c\u539f\u56e0\u3060\u301c!! \u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u30b3\u30fc\u30c9\u5185\u3067\u3001\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\u90e8\u5206\u3082\u767a\u898b\u3067\u304d\u307e\u3057\u305f\u3002\u3084\u306f\u308a\u3001latin1\u306b\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"hljs\"><code class=\"php\">      $alterSQL = &quot;ALTER TABLE `{$table}` CHANGE `body` `body` LONGTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;&quot;;\r\n<\/code><\/pre>\n<p>\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u3001utf8\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n<pre>\r\nmysql> ALTER TABLE wp_pluginname CHANGE `body` `body` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;\r\nQuery OK, 0 rows affected (0.00 sec)\r\nRecords: 0  Duplicates: 0  Warnings: 0\r\n\r\nmysql> show create table wp_pluginname;\r\n+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table          | Create Table                                                                                                                                                                                                                                                                                               |\r\n+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| wp_pluginname | CREATE TABLE `wp_pluginname` (\r\n  `Cache_id` int(10) NOT NULL AUTO_INCREMENT,\r\n  `URL` text NOT NULL,\r\n  `updated` datetime DEFAULT NULL,\r\n  `body` longtext,\r\n  PRIMARY KEY (`Cache_id`),\r\n  UNIQUE KEY `URL` (`URL`(255)),\r\n  KEY `Updated` (`updated`)\r\n) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 |\r\n+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (0.00 sec)\r\n\r\n<\/pre>\n<p>utf8\u306b\u306a\u3063\u305f\u3063\u307d\u3044\u3067\u3059\u3002\u30c7\u30fc\u30bf\u3092\u633f\u5165\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<pre>\r\nmysql> insert into wp_pluginname (URL, body, updated) values (\"CCC\", \"CCC\u3046\u3046\u3046\", NOW());\r\nQuery OK, 1 row affected (0.00 sec)\r\n\r\nmysql> select * from wp_pluginname;\r\n+----------+----------------------------------------+---------------------+--------------+\r\n| Cache_id | URL                                    | updated             | body         |\r\n+----------+----------------------------------------+---------------------+--------------+\r\n|       10 | AAA                                    | 2015-07-11 08:23:34 | AAA          |\r\n|       11 | BBB                                    | 2015-07-11 08:24:09 | BBB???       |\r\n|       12 | CCC                                    | 2015-07-11 08:33:49 | CCC\u3046\u3046\u3046    |\r\n+----------+----------------------------------------+---------------------+--------------+\r\n3 rows in set (0.00 sec)\r\n\r\n<\/pre>\n<p>\u3084\u308a\u307e\u3057\u305f! \u3061\u3083\u3093\u3068\u3001\u65e5\u672c\u8a9e\u304c\u4fdd\u5b58\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5f8c\u3001\u5b9f\u969b\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u64cd\u4f5c\u3067\u3001\u6587\u5b57\u5316\u3051\u3057\u7121\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a\u304c\u3042\u3063\u305f\u306e\u306f\u77e5\u3063\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u307e\u3055\u304b\u30c6\u30fc\u30d6\u30eb\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u500b\u5225\u306b\u5909\u66f4\u3067\u304d\u308b\u3068\u306f!! \u6b63\u78ba\u306b\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u3088\u308a\u3082\u3063\u3068\u7d30\u304b\u3044\u3001\u5217\u306e\u30ec\u30d9\u30eb\u3067\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u554f\u984c\u3092\u89e3\u6c7a\u3059\u308b\u307e\u3067\u3001\u304b\u306a\u308a\u306e\u6642\u9593\u304c\u304b\u304b\u308a\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u65e5\u672c\u8a9e\u5316\u3055\u308c\u3066\u3044\u306a\u3044\u3001WordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u3001\u65e5\u672c\u8a9e\u5316\u3057\u3066\u4f7f\u304a\u3046\u3068\u3057\u3066\u3044\u307e\u3059\u3002\u4eca\u56de\u3001MySQL\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a\u304c\u3001utf8\u3067\u306f\u306a\u304flatin1\u306b\u306a\u3063\u3066\u3044\u3066\u3001\u304b\u306a\u308a\u306f\u307e\u308a\u307e\u3057\u305f\u3002 VC [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":15505,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"\u65b0\u3057\u3044\u8a18\u4e8b\u300eWordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u6539\u9020\u3057\u3066\u3044\u3066MySQL\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306b\u306f\u307e\u308b\u300f\u3092\u6295\u7a3f\u3057\u307e\u3057\u305f\u3002\u8aad\u3093\u3067\u3044\u305f\u3060\u3051\u308b\u3068\u5b09\u3057\u3044\u3067\u3059\u3002","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[33,5],"tags":[],"class_list":["post-15497","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","category-computer"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/oichinote.com\/plus\/files\/2015\/07\/20150711mysql-db-charset.png","jetpack-related-posts":[{"id":12031,"url":"https:\/\/oichinote.com\/plus\/2014\/06\/localize-with-gettext-and-poedit.html","url_meta":{"origin":15497,"position":0},"title":"WordPress\u306e\u30c6\u30fc\u30de\u3092xgettext\u3068Poedit\u3067\u65e5\u672c\u8a9e\u5316[\u8ffd\u8a18\u3042\u308a]","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2014\u5e746\u67085\u65e5","format":false,"excerpt":"\u524d\u304b\u3089\u3001\u300c\u3084\u308d\u3046\u3001\u3084\u308d\u3046\u300d\u3068\u306f\u601d\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u3084\u3063\u3068\u3067\u304d\u307e\u3057\u305f\u3002\u30c6\u30fc\u30de\u306e\u30ed\u30fc\u30ab\u30e9\u30a4\u30ba(\u65e5\u672c\u8a9e\u5316)\u2026","rel":"","context":"FreeBSD","block_context":{"text":"FreeBSD","link":"https:\/\/oichinote.com\/plus\/category\/freebsd"},"img":{"alt_text":"POT\u3092\u958b\u304f","src":"https:\/\/i0.wp.com\/oichinote.com\/plus\/files\/2014\/06\/20140605poedit-open.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":15565,"url":"https:\/\/oichinote.com\/plus\/2015\/07\/updating-a-plugin-for-amazon.html","url_meta":{"origin":15497,"position":1},"title":"Amazon\u7528\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u5927\u6539\u9020","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2015\u5e747\u670818\u65e5","format":false,"excerpt":"Amazon\u30a2\u30bd\u30b7\u30a8\u30a4\u30c8\u306b\u5bfe\u5fdc\u3059\u308b\u305f\u3081\u306b\u3001\u6b21\u306eWordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002\u305d\u308c\u307e\u3067\u3001\u2026","rel":"","context":"Web-log\u30fb\u30b3\u30b3\u30ed\u30b0\u95a2\u9023","block_context":{"text":"Web-log\u30fb\u30b3\u30b3\u30ed\u30b0\u95a2\u9023","link":"https:\/\/oichinote.com\/plus\/category\/webblog-cocolog"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15293,"url":"https:\/\/oichinote.com\/plus\/2015\/06\/developping-env-with-vccw.html","url_meta":{"origin":15497,"position":2},"title":"VCCW\u3067WordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u958b\u767a\u74b0\u5883\u3092\u69cb\u7bc9","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2015\u5e746\u670817\u65e5","format":false,"excerpt":"WordPress\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u958b\u767a\u3057\u3088\u3046\u3068\u3057\u3066\u3044\u307e\u3059\u3002 Kindle50%\u30dd\u30a4\u30f3\u30c8\u9084\u5143\u3068\u805e\u3044\u3066\u300cW\u2026","rel":"","context":"WordPress","block_context":{"text":"WordPress","link":"https:\/\/oichinote.com\/plus\/category\/wordpress"},"img":{"alt_text":"WordPress","src":"https:\/\/i0.wp.com\/oichinote.com\/plus\/files\/2015\/06\/20150617vccw-dev.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":20627,"url":"https:\/\/oichinote.com\/plus\/2017\/06\/vccw-on-freebsd.html","url_meta":{"origin":15497,"position":3},"title":"FreeBSD\u3067VCCW\u3092\u4f7f\u3063\u3066WordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u958b\u767a[\u8ffd\u8a18\u3042\u308a]","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2017\u5e746\u670823\u65e5","format":false,"excerpt":"\u30b5\u30fc\u30d0\u30fc\u304c\u5fa9\u6d3b\u3057\u3066\u3001\u3084\u308a\u305f\u3044\u3053\u3068\u304c\u3084\u3063\u3068\u3084\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u305d\u306e\u4e00\u3064\u304c\u3001\u30b5\u30fc\u30d0\u30fc(FreeBSD\u2026","rel":"","context":"FreeBSD","block_context":{"text":"FreeBSD","link":"https:\/\/oichinote.com\/plus\/category\/freebsd"},"img":{"alt_text":"FreeBSD\u3067VCCW","src":"https:\/\/i0.wp.com\/oichinote.com\/plus\/files\/2017\/06\/20170623vccw-on-freebsd.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":16825,"url":"https:\/\/oichinote.com\/plus\/2016\/01\/cannot-mount-synced-folder-on-vagrant.html","url_meta":{"origin":15497,"position":4},"title":"Vagrant\u3067\u5171\u6709\u30d5\u30a9\u30eb\u30c0\u3092\u30de\u30a6\u30f3\u30c8\u3067\u304d\u306a\u304b\u3063\u305f","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2016\u5e741\u670820\u65e5","format":false,"excerpt":"Vagrant\u4e0a\u306eVCCW\u3092\u4f7f\u3063\u3066\u3001WordPress\u306e\u30c6\u30b9\u30c8\u74b0\u5883\u306b\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002 VCCW\u3067Wor\u2026","rel":"","context":"Mac","block_context":{"text":"Mac","link":"https:\/\/oichinote.com\/plus\/category\/mac"},"img":{"alt_text":"VCCW mounted","src":"https:\/\/i0.wp.com\/oichinote.com\/plus\/files\/2016\/01\/20160120vccw-mounted.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":17344,"url":"https:\/\/oichinote.com\/plus\/2016\/03\/how-to-test-wordpress-theme.html","url_meta":{"origin":15497,"position":5},"title":"WordPress\u30c6\u30fc\u30de\u306e\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8","author":"\u304a\u5e02\u306e\u304b\u305f","date":"2016\u5e743\u670827\u65e5","format":false,"excerpt":"\u672c\u30a6\u30a7\u30d6\u30b5\u30a4\u30c8\u3067\u4f7f\u3046\u305f\u3081\u306e\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6\u30c7\u30b6\u30a4\u30f3\u5bfe\u5fdc\u306e\u30c6\u30fc\u30de\u304c\u3001\u3068\u308a\u3042\u3048\u305a\u5168\u9762\u5c55\u958b\u3067\u304d\u308b\u30ec\u30d9\u30eb\u306b\u306a\u308a\u307e\u2026","rel":"","context":"Web-log\u30fb\u30b3\u30b3\u30ed\u30b0\u95a2\u9023","block_context":{"text":"Web-log\u30fb\u30b3\u30b3\u30ed\u30b0\u95a2\u9023","link":"https:\/\/oichinote.com\/plus\/category\/webblog-cocolog"},"img":{"alt_text":"\u30c6\u30fc\u30de\u306e\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8","src":"https:\/\/i0.wp.com\/oichinote.com\/plus\/files\/2016\/03\/20160327wordpress-theme-unit-test.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/posts\/15497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/comments?post=15497"}],"version-history":[{"count":6,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/posts\/15497\/revisions"}],"predecessor-version":[{"id":15504,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/posts\/15497\/revisions\/15504"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/media\/15505"}],"wp:attachment":[{"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/media?parent=15497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/categories?post=15497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oichinote.com\/plus\/wp-json\/wp\/v2\/tags?post=15497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}