WordPress.org

Ready to get started?Download WordPress

Forums

Database structure - Question about meta tables (2 posts)

  1. b-rad
    Member
    Posted 4 years ago #

    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?

  2. b-rad
    Member
    Posted 4 years ago #

    nevermind, figured it out. it's the PHP serialized representation of some object (array I assume).

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.