Support » Everything else WordPress » Database structure – Question about meta tables

  • Nosing through the tables today I noticed that the usermeta and postmeta tables both have meta_value fields and what caught my eye was the unusual format the data in these fielfds was in. Values like a:3:{i:0;s:13:"trackbacksdiv";i:1;s:10:"postcustom";i:2;s:7:"slugdiv";} and
    a:6:{s:5:"width";i:250;s:6:"height";i:323;s:14:"hwstring_small";s:22:"height='96' width='74'";s:4:"file";s:72:"/var/www/internal_html/wp-content/uploads/2009/04/wireframes7.jpg";s:5:"sizes";a:2:{s:9:"thumbnail";a:3:{s:4:"file";s:23:"wireframes7-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}s:6:"medium";a:3:{s:4:"file";s:23:"wireframes7-232x300.jpg";s:5:"width";i:232;s:6:"height";i:300;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}} show up in there.

    But unlike some other databases I’ve seen that delimit data with rarely used characters (e.g. ~) I had no idea how this was being used. Does anyone have some insight as to what this type of data is and why it’s stored this way?

Viewing 1 replies (of 1 total)
  • nevermind, figured it out. it’s the PHP serialized representation of some object (array I assume).

Viewing 1 replies (of 1 total)
  • The topic ‘Database structure – Question about meta tables’ is closed to new replies.