{"id":1031,"date":"2021-10-15T06:45:56","date_gmt":"2021-10-15T06:45:56","guid":{"rendered":"https:\/\/mio-web.net\/pcsupport\/?p=1031"},"modified":"2021-10-15T06:45:58","modified_gmt":"2021-10-15T06:45:58","slug":"%e3%80%80sqlite2%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%ef%bc%88euc%ef%bc%89%e3%80%80%e2%86%92%e3%80%80sqlite3%ef%bc%88utf-8%ef%bc%89%e3%81%ab%e5%a4%89%e6%8f%9b","status":"publish","type":"post","link":"https:\/\/mio-web.net\/pcsupport\/archives\/1031\/","title":{"rendered":"\u3000SQLITE2\u30d5\u30a1\u30a4\u30eb\uff08EUC\uff09\u3000\u2192\u3000SQLITE3\uff08UTF-8\uff09\u306b\u5909\u63db"},"content":{"rendered":"\n<p>DB\u306ftksqlite\u3092\u4f7f\u3063\u3066 utf-8 \u306b\u3057\u3066\u66f8\u304d\u51fa\u3059\u3000\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u4fdd\u5b58 001.csv\u3068\u3059\u308b<br>\u3053\u306ecsv\u30d5\u30a1\u30a4\u30eb\u3092\u3000DB Browser \u306b\u53d6\u308a\u8fbc\u3080<\/p>\n\n\n\n<p>\u2192\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u2192\u540d\u524d\u3092\u3064\u3051\u3066\u4fdd\u5b58\uff08info.sqlite3\uff09<br>\u2192\u30c6\u30fc\u30d6\u30eb\u540d\u805e\u3044\u3066\u304f\u308b\u304c\u30ad\u30e3\u30f3\u30bb\u30eb\uff08\u30c6\u30fc\u30d6\u30eb\u306e\u306a\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210\u3055\u308c\u308b\uff09<br>\u2192\u30d5\u30a1\u30a4\u30eb\u3000\u30a4\u30f3\u30dd\u30fc\u30c8\u3000CSV\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u3078\uff08001.csv\u9078\u629e\uff09OK\u3000\u2192\u300c001\u300d\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u4fdd\u5b58\u3055\u308c\u308b<br>\u2192\u30c6\u30fc\u30d6\u30eb\u5909\u66f4\uff08\u540d\u524d\u3092info\u306b\u3059\u308b\uff09\uff08i_id\u30d5\u30a3\u30fc\u30eb\u30c9\u3092PK\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u308b\uff09<br>\u2192\u30ed\u30fc\u30ab\u30eb\u3067\u306f\u300c\u4e00\u3064\u4e0a\u306e\u30d5\u30a9\u30eb\u30c0\u300d\u3068\u3044\u3046\u30d5\u30a9\u30eb\u30c0\u5185\u306edb\u30d5\u30a1\u30a4\u30eb\u306b\u683c\u7d0d\u3057\u3066\u304a\u304f<br>\u2192db\u30d5\u30a9\u30eb\u30c0\u306b\u30a2\u30c3\u30d7\u3059\u308b\u3000db\u30d5\u30a9\u30eb\u30c0(777) info.sqlite3(666)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB\u306ftksqlite\u3092\u4f7f\u3063\u3066 utf-8 \u306b\u3057\u3066\u66f8\u304d\u51fa\u3059\u3000\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u4fdd\u5b58 001.csv\u3068\u3059\u308b\u3053\u306ecsv\u30d5\u30a1\u30a4\u30eb\u3092\u3000DB Browser \u306b\u53d6\u308a\u8fbc\u3080 \u2192\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u2192\u540d\u524d\u3092\u3064\u3051\u3066\u4fdd\u5b58\uff08info.sql [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"vkexunit_cta_each_option":"","footnotes":""},"categories":[15,36],"tags":[],"class_list":["post-1031","post","type-post","status-publish","format-standard","hentry","category-cgi","category-web"],"_links":{"self":[{"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/posts\/1031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/comments?post=1031"}],"version-history":[{"count":1,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/posts\/1031\/revisions"}],"predecessor-version":[{"id":1032,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/posts\/1031\/revisions\/1032"}],"wp:attachment":[{"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/media?parent=1031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/categories?post=1031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/tags?post=1031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}