{"categories":["Rails","MySQL"],"description":"Rails\u306eMigration\u3067:binary\u3068\u3059\u308b\u3068MySQL\u3067\u306fblob\u578b\u306b\u306a\u308b\u3002 create_table :files do |t| t.column :data, :binary end MySQL\u3067\u306eblob\u578b \u578b \u30b5\u30a4\u30ba TINYBLOB 256byte BLOB 64KB MEDIUMBLOB 16MB LONGBLOB 4GB Migration\u3067\u306f:binary\u3057\u304b\u9078\u629e\u80a2\u304c\u306a\u304fMySQL\u3060\u3068blob\u578b\u3068\u3057\u3066\u89e3\u91c8\u3055\u308c\u308b\u3002 \u753b\u50cf\u30d5\u30a1\u30a4\u30eb\u306a\u3089\u3070\u666e\u901a\u306b\u5927\u4e08\u592b\u3060\u3051\u3069\u4ed6\u306e\u30d5\u30a1\u30a4\u30eb\u3082\u6271\u3046\u3068\u82e6\u3057\u3044\u3002SQL\u3067\u76f4\u306b\u5c5e\u6027\u3092\u5b9a\u7fa9\u3059\u308b\u3053\u3068\u3067\u3053\u306e\u554f\u984c\u306f\u89e3\u6d88\u3059\u308b class AlterModifyLon\u2026","published":"2009-08-06 10:45:12","image_url":null,"provider_name":"Hatena Blog","provider_url":"https://hatena.blog","title":"Rails + MySQL\u3067\u306eblob\u578b\u306e\u6271\u3044","url":"https://chulip.org/entry/20090806/1249523112","height":"190","author_url":"https://blog.hatena.ne.jp/arcright/","author_name":"arcright","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fchulip.org%2Fentry%2F20090806%2F1249523112\" title=\"Rails + MySQL\u3067\u306eblob\u578b\u306e\u6271\u3044 - chulip.org\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"chulip.org","version":"1.0","type":"rich","width":"100%","blog_url":"https://chulip.org/"}