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. What is an ORM, how does it work, and how should I use one? [closed]
  43. What is this JavaScript “require”?
  44. Database vs File system storage
  45. WPDB Insert or if exists Update
  46. WP Multisite: load content from site X on site Y
  47. How does $wpdb handle COUNT(*)
  48. Login in WordPress using external database data
  49. Shared Members between two different wordpress installations with different databases
  50. Efficiency on displaying random authors based on large database
  51. How to write Hebrew characters?
  52. Error establishing a database connection – with Debug Data
  53. Finding the login page from database?
  54. When and why should I use $wpdb different return types?
  55. Database with mixed collation (utf8mb4 & utf8_general_ci)
  56. Adding new row to wp_post table
  57. Extracting the post_id via the wp_insert_post action (external db query)
  58. How to interact with another wordpress install on same database?
  59. batch UPDATE autoload value in wp_options table
  60. “The link you followed has expired” & “Error while saving” messages when adding new post
  61. input data and output table [closed]
  62. WP character encoding error after sharing post on Facebook �
  63. Sending data with multi step form to wp database
  64. WordPress query is not returning proper results
  65. Connection refused on locahost after importing database?
  66. WSOD 3.9.1 – Tried Everything so far
  67. Can you refresh ONLY the wordpress adminbar and not the whole page?
  68. Sending posts from Python to WordPress
  69. Problem migrating to localhost
  70. WooCommerce order refund get qty refunded
  71. Design problems when exporting remote database for local development
  72. How do you render posts from outside wordpress?
  73. Second ezSQL initialization for MSSQL
  74. Fetch a single row from a custom table for to a given ID
  75. Database create or redirect
  76. Database structure cheatsheet
  77. White Screen in Home Page
  78. Continuous SQL query errors from outside source
  79. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  80. Migrate Users From laravel to wordpress
  81. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  82. how add more field to wp user and save it to database
  83. Deleted products from woocommerce are still in the database
  84. How do I cleanup my database with data that is no longer being used?
  85. Malware in old website – how to migrate?
  86. error establishing database connection (WAMP + filezilla)
  87. How to display $wpdb->insert_id; value on redirected page
  88. Should I Use only wpdb Class to Write Custom Queries?
  89. Auto populate form fields based on serial input or pull listings from other websites?
  90. How to extract some part of WordPress full source code
  91. Error establishing a database connection for some files
  92. Hash user emails in database?
  93. Database Name Change
  94. Weird characters in title if it contain “ ”
  95. Where To Find bb_profile_data(); In bbPress?
  96. One information repeated on multiple locations on one site [closed]
  97. Showing Error(TAble already exist)
  98. Cant Connect to Database
  99. WordPress database connection failed, while mysql client is working [closed]
  100. Combining two select posts from mysql – to get least viewed posts