{"published":"2008-06-20 01:13:20","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fakm.hatenadiary.org%2Fentry%2F20080620%2F1213978400\" title=\" BLOB\u306e\u6700\u5927\u9577 - akimatter\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","url":"https://akm.hatenadiary.org/entry/20080620/1213978400","provider_name":"Hatena Blog","blog_title":"akimatter","provider_url":"https://hatena.blog","image_url":null,"height":"190","author_url":"https://blog.hatena.ne.jp/akm/","width":"100%","author_name":"akm","title":" BLOB\u306e\u6700\u5927\u9577","blog_url":"https://akm.hatenadiary.org/","categories":["rails","mysql"],"type":"rich","description":"BLOB[(M))] \u6700\u5927\u957765,535\u30d0\u30a4\u30c8\u306e\u30d0\u30a4\u30ca\u30ea MEDIUMBLOB \u6700\u5927\u957716,777,215\u30d0\u30a4\u30c8\u306e\u30d0\u30a4\u30ca\u30ea LONGBLOB] \u6700\u5927\u95774,294,967,295\u30d0\u30a4\u30c8\u3042\u308b\u3044\u306f4G\u30d0\u30a4\u30c8\u306e\u30d0\u30a4\u30ca\u30ea \u524d\u306b\u898b\u304b\u3051\u3066\u77e5\u3063\u3066\u305f\u306e\u306b\u3001\u3059\u3063\u304b\u308a\u5fd8\u308c\u3066\u305f\u3002BLOB\u3060\u306864K\u3057\u304b\u5165\u3089\u306a\u3044\u3002\u3061\u3087\u3063\u3068\u5927\u304d\u306a\u30d5\u30a1\u30a4\u30eb\u3092DB\u306b\u3057\u307e\u304a\u3046\u3068\u3059\u308b\u3068\u300164KB\u3067\u3076\u3063\u305f\u5207\u3089\u308c\u3066\u5165\u308b\u306e\u3067\u3001\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u306f\u58ca\u308c\u3066\u3057\u307e\u3046\u3002 def self.up if /mysql/i =~ adapter_name change_column(:uploaded_files, :data, \"longblob\") end end d\u2026"}