[wp-trac] [WordPress Trac] #13310: Extend option_name to varchar(255)

[WordPress Trac]

#13310: Extend option_name to varchar(255)
-----------------------------------------+-----------------------
 Reporter:  scribu                       |       Owner:  pento
     Type:  enhancement                  |      Status:  assigned
 Priority:  normal                       |   Milestone:  4.4
Component:  Database                     |     Version:
 Severity:  normal                       |  Resolution:
 Keywords:  has-patch reporter-feedback  |     Focuses:
-----------------------------------------+-----------------------

Comment (by Hube2):

 Needed to do some reading on index lengths and utf8mb4.. Unique key max
 length 767 bytes / 4 = 191.75

 191 is better than 64 and not having queries silently fail is one of the
 reasons why some have been interested in this for so long.

 My vote would be for 191.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/13310#comment:72>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform