[wp-trac] [WordPress Trac] #55942: Add a "type" field to the meta and options tables

[WordPress Trac]

#55942: Add a "type" field to the meta and options tables
-------------------------------------------------+-------------------------
 Reporter:  azaozz                               |       Owner:  (none)
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Database                             |     Version:
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch has-unit-tests needs-      |     Focuses:
  testing                                        |  performance
-------------------------------------------------+-------------------------

Comment (by azaozz):

 Another option here (which I'm not fond off, but is a possible solution)
 would be to only add a `TINYINT` field to these tables indicating whether
 the data in the value field is serialized or not. That perhaps can be `0`
 for default/unknown, `1` for serialized, and maybe `2` for JSON encoded.
 This will reduce complexity and won't have back-compat problems, but will
 also miss the chance to further improve the options and meta APIs.

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