[B! MySQL][Rails] k_oshimaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

k_oshima id:k_oshima

MySQLã¨Railsã«é–¢ã™ã‚‹k_oshimaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Rails(ActiveRecord)ã¨MySQLã§utf8mb4ã‚’æ‰±ã†è¨å®š - Qiita
ActiveRecordã‹ã‚‰utf8mb4ã‚’æ‰±ãˆãªã„ä¸»ãªç†ç”± ActiveRecordã®stringåž‹ã‚«ãƒ©ãƒ ãŒvarchar(255)ã§å®šç¾©ã•ã‚Œã‚‹ã®ã§ã€utf8mb4ã§ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚ãƒ¼ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ãŒ767byteã‚’è¶…ãˆã¦ã—ã¾ã†ã€‚ ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes ã“ã®å•é¡Œã‚’MySQLã®è¨å®šã¨Railsã¸ã®ãƒ‘ãƒƒãƒã§è§£æ±ºã™ã‚‹ã€‚ MySQLã®è¨å®š æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’utf8mb4ã§é‹ç”¨ã™ã‚‹ãŸã‚ã«ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚ãƒ¼ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã‚’æ‹¡å¼µã™ã‚‹ã€‚ innodb_large_prefixã‚’enableã«ã™ã‚‹ 1ã‚’æœ‰åŠ¹ã«ã™ã‚‹ãŸã‚ã«ã€innodb_file_formatã‚’Barracudaã«ã™ã‚‹ 1ã‚’æœ‰åŠ¹ã«ã™ã‚‹ãŸã‚ã«ã€innodb_file_per_tableã‚’enableã«ã™ã‚‹ innod
k_oshima 2018/05/23
Rails

MySQL

utf8mb4
ãƒªãƒ³ã‚¯
ActiveRecordã‚’utf8mb4ã§å‹•ã‹ã™ - Qiita
ã‚‚ã†MySQL 5.5 GAãŒå‡ºã¦ã‹ã‚‰ä¸€å¹´ãŒçµŒã¡ã€MySQL 5.6 GAã‚‚ãã‚ãã‚å‡ºã‚‹ã“ã‚ã ã—ã€æ–°è¦ã§ä½œã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯utf8mb4ã§ã„ããŸã„ã®ã§ãã®æ–¹æ³•ã€‚ ã¾ãšã€mysql2ãŒ0.3.11ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯utf8mb4ã«å¯¾å¿œã—ã¦ãªã„ã®ã§ã€ãã‚Œã‚ˆã‚Šæ–°ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã§encoding: utf8mb4ã§æŽ¥ç¶šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã¤ãŽã«ActiveRecord::Migrationã§utf8mb4ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ã‚ˆã†ã«ã‚³ãƒ³ãƒ•ã‚£ã‚°ã§charsetã¨collationã‚’æŒ‡å®šã—ã¾ã™ã€‚
k_oshima 2018/05/23
Rails

MySQL

utf8mb4
ãƒªãƒ³ã‚¯
UTCãªã‚µãƒ¼ãƒãƒ¼ã¨MySQLã¨ã§ä½¿ã†Railsã®æ™‚é–“ã®æ‰±ã„ã«ã¤ã„ã¦èª¿ã¹ãŸ | kanonjiã®ãƒ–ãƒã‚°
ã¾ãšå‰æã¨ãªã‚‹ç’°å¢ƒã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ ã‚³ãƒ¼ãƒ‰å†…ã¨ã„ã†ã®ã¯ã€ä¾‹ãˆã°ã‚¤ãƒ™ãƒ³ãƒˆç”¨ã®ãƒšãƒ¼ã‚¸ã‚’ä½œã£ãŸæ™‚ã€æŒ‡å®šã®æ—¥æ™‚ã¾ã§ã¯ã‚¢ã‚¯ã‚»ã‚¹å‡ºæ¥ãªã„ã‚ˆã†ã«ã™ã‚‹ç”¨ãªäº‹ã‚’ã€ã¾ãã‚³ãƒ¼ãƒ‰ã«ãƒãƒ¼ãƒ‰ã‚³ãƒ¼ãƒ‰ã™ã‚‹éš›ã«ã€OSãŒUTCã ã¨ã—ã¦ã‚‚æ—¥æœ¬æ™‚é–“ã§æ›¸ããŸã„ã¨ã„ã†äº‹ã€‚ # Set Time.zone default to the specified zone and make Active Record auto-convert to this zone. # Run "rake -D time" for a list of tasks for finding time zone names. Default is UTC. config.time_zone = 'Tokyo' rails_project_dir/config/application.rb ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‹ã‚‰ä¸Šè¨˜ã ã‘è¨å®šã‚’å¤‰æ›´ã™ã‚‹ã€‚ Timeã¯ä½¿ã‚ãšã«Activ
k_oshima 2015/04/01
ç†è§£ã—ãªã„ã§ã¾ã¨ã‚ã¦ã‚ã‚‹

AWS

MySQL

Rails

Rails4

timezone
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

MySQLã¨Railsã«é–¢ã™ã‚‹k_oshimaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

MySQLã¨Railsã«é–¢ã™ã‚‹k_oshimaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

Rails(ActiveRecord)ã¨MySQLã§utf8mb4ã‚’æ‰±ã†è¨­å®š - Qiita

ActiveRecordã‚’utf8mb4ã§å‹•ã‹ã™ - Qiita

UTCãªã‚µãƒ¼ãƒãƒ¼ã¨MySQLã¨ã§ä½¿ã†Railsã®æ™‚é–“ã®æ‰±ã„ã«ã¤ã„ã¦èª¿ã¹ãŸ | kanonjiã®ãƒ–ãƒ­ã‚°

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

MySQLã¨Railsã«é–¢ã™ã‚‹k_oshimaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

Rails(ActiveRecord)ã¨MySQLã§utf8mb4ã‚’æ‰±ã†è¨å®š - Qiita

ActiveRecordã‚’utf8mb4ã§å‹•ã‹ã™ - Qiita

UTCãªã‚µãƒ¼ãƒãƒ¼ã¨MySQLã¨ã§ä½¿ã†Railsã®æ™‚é–“ã®æ‰±ã„ã«ã¤ã„ã¦èª¿ã¹ãŸ | kanonjiã®ãƒ–ãƒã‚°

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹