Structure of postmeta meta_value for woocommerce product download

In short, this is serialized data and this is how data is stored from a custom field (and many other datastrings) in the db.

s:114 is auto generated and simply means that the value http://localhost/wp-content/uploads/woocommerce_uploads/2014/09/test-file.pdf is a string and is 114 characters long. This is used when the data is read and used. If the URL value changes, the string length will change as the length of the string changes

You will need to go and have a look at data serializing and unserializing

Related Posts:

  1. Why WordPress choose data serialization over json_encode?
  2. Dealing with Many Meta Values, 30+
  3. What is the most secure way to store post meta data in WP?
  4. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  5. Meta query interfering with orderby relevance
  6. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  7. Is removing orphaned wp_postmeta records safe?
  8. How to solve slow WordPress site caused by attachment_metadata
  9. Delete all post meta except featured image
  10. WooCommerce – Query for ordered products
  11. Is it possible to store visitors IPs in wp_postmeta table?
  12. Multiple postmeta with same name for one post in wp_postmeta table
  13. Delete all post meta except featured image Using SQL
  14. One post carries 30 postmeta values, is this too much?
  15. delete post meta from db, even if does not exist?
  16. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  17. Storing data for a wordpress plugin
  18. Where does the actual data stored by add_post_meta
  19. Delete transients in website
  20. Routine to convert custom post meta from old to new value
  21. Cleanup: best way to remove WooCommerce comments from the wp_comments table
  22. Saving zero as meta value
  23. Uknown meta entries in wp_postmeta
  24. Does post_meta data need to be unserialzed?
  25. WooCommerce: remove sample & dummy data
  26. Link image with data from the wpdb
  27. Woocommerce – Check product stock availability from external database
  28. Custom Post Type not showing anything added by code anymore?
  29. Compare User meta_value with Product meta_value
  30. How to save EXIF metadata in WordPress database?
  31. _wp_attachment_metadata is not being added to database when PDF files uploaded
  32. “BS_” rows in postmeta table
  33. Migrating meta_key and meta_value from old theme to new one
  34. update_post_meta performance in a loop woocommerce
  35. update_post_meta performance in a loop woocommerce
  36. Database structure for thousands of posts
  37. How much post meta data is too much?
  38. How do i get value from wp_postmeta?
  39. Recommended Post Structure for DB Storage
  40. SQL query : Select a thumbnail for a media
  41. What is table `wp_woocommerce_termmeta` for? [closed]
  42. wp_update_post function exclude specific field
  43. What is an ORM, how does it work, and how should I use one? [closed]
  44. What is the difference between an ORM and an ODM?
  45. What is this JavaScript “require”?
  46. Rename a table in MySQL
  47. How should I tackle –secure-file-priv in MySQL?
  48. What is this JavaScript “require”?
  49. What is “Advanced” SQL?
  50. What’s the difference between identifying and non-identifying relationships?
  51. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  52. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  53. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  54. What are the differences between B trees and B+ trees?
  55. MySQL SELECT increment counter
  56. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  57. Example of a strong and weak entity types
  58. Oracle SQL query for Date format
  59. phpMyAdmin – Error > Incorrect format parameter?
  60. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  61. Difference between partition key, composite key and clustering key in Cassandra?
  62. How SID is different from Service name in Oracle tnsnames.ora
  63. What is a relation in database terminology?
  64. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  65. Database vs File system storage
  66. Can I have multiple primary keys in a single table?
  67. Exclude Statement in SQL
  68. How do you query for “is not null” in Mongo?
  69. What is a file based database?
  70. Is it fine to have foreign key as primary key?
  71. Storing Images in DB – Yea or Nay?
  72. Using wpdb to connect to a separate database
  73. how to Optimize WordPress database for 10 million post? [duplicate]
  74. MySQL Database User: Which Privileges are needed?
  75. Why is my database import losing text widget data?
  76. Database synchronization between dev/staging and production
  77. Keeping WP database synced across multiple developers using git
  78. Post meta vs separate database tables
  79. WPDB Insert or if exists Update
  80. Multiple developers / editors working on a site in progress
  81. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  82. get_results using wpdb
  83. Will it break my site if I delete all transient records in wp_options table?
  84. Checking if Database Table exists
  85. What’s the simplest way to backup my WordPress database?
  86. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  87. $wpdb won’t insert NULL into table column
  88. Relaunch 4.2 utf8mb4 database upgrade
  89. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  90. Safest way to bulk delete post revisions
  91. Please explain how WordPress works with MySQL character set and collation at a low level
  92. Solution for database version control and deployment?
  93. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  94. How many users can WordPress handle?
  95. Get error messages when $wpdb->insert() returns false?
  96. Detecting errors generated by $wpdb->get_results()
  97. Staging sites, how do you manage synchronising updates in the DB?
  98. Does dbDelta delete columns as well?
  99. How to get the post publish date outside the loop?
  100. MariaDB as a backend database