Ruby on Railsã§MySQLã«ç”»åƒã‚’æ ¼ç´ã™ã‚‹ - yuumi3ã®ãŠä»•äº‹æ—¥è¨˜è¨³ã‚ã£ã¦ã€Ruby on Railsã§MySQLã«ç”»åƒã‚’æ ¼ç´ã—使ã†å®Ÿé¨“ã‚’ã—ãŸã€‚ migrationã§ã®æŒ‡å®š ç”»åƒã‚’æ ¼ç´ã™ã‚‹ã‚«ãƒ©ãƒ 㯠migration ã§ã¯ binary を指定ã—ã¾ã™ã€‚ãŸã ã—ã€ãã®ã¾ã¾ã§ã¯ 64Kbyteã¾ã§ã—ã‹æ ¼ç´å‡ºæ¥ãªã„ blobåž‹ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ã“れを mediumblobåž‹ã«ã™ã‚‹ã«ã¯ã€ migrationファイル㧠:limit => (16*1024*1024 - 1) を指定ã—ã¾ã™ã€‚ def self.up create_table :table_name do |t| t.binary :column_name, :limit => (16*1024*1024 - 1) t.timestamps end endãƒãƒƒãƒˆã‚’検索ã™ã‚‹ã¨ã€mediumblob指定ã®ç‚ºã« execute ã§MySQLã®SQL文を書ãよã†ãªè¨˜äº‹ãŒè¦‹ã¤ã‹ã‚Šã¾ã™ãŒã€ãã‚“ãªé¢å€’ã¯ã„ã‚Šã¾ã›ã‚“
{{#tags}}- {{label}}
{{/tags}}