WordPress的wp_post表中数据以何种形式存储？确认非JSON格式

Hey there! Let's break down exactly how data is stored in WordPress's wp_posts table, and put to rest any confusion: it does NOT use JSON format for core storage.

First, keep in mind that wp_posts is a standard relational database table—each row represents a single post, page, attachment, or custom content type, and every column holds data in a straightforward, non-JSON structure:

• ID: A numeric integer acting as the unique identifier for each piece of content.
• post_title: Plain text (or occasionally simple HTML) for the content's title—no JSON here.
• post_content: This is where your main content lives, stored as HTML (with optional Gutenberg block comments). Even if you use the block editor, content isn't saved as JSON. Instead, it looks like structured HTML wrapped in special block markers, for example:

  <!-- wp:heading -->
  <h2>My Custom Heading</h2>
  <!-- /wp:heading -->
  <!-- wp:paragraph -->
  <p>This is my post content, stored as plain HTML with block-specific comments.</p>
  <!-- /wp:paragraph -->
  

• post_excerpt: A short text snippet (or simple HTML) for previews and summaries.
• post_status: A string value like publish, draft, or pending to define the content's visibility state.
• post_type: A string to categorize content type, e.g., post, page, attachment, or custom post types you might create.

To emphasize: None of the core fields in wp_posts use JSON storage. While some plugins might store complex metadata in the separate wp_postmeta table using JSON for meta_value, that's a distinct table and not part of the core wp_posts structure.

内容的提问来源于stack exchange，提问作者Yogesh Tanwar