Table

Local-first converters, viewers, and file tools

راهنمای محصول · 6 دقیقه مطالعه

Nulls, empty strings, and blanks: CSV semantics in real pipelines

How empty fields round-trip: SQL NULL vs empty string vs whitespace-only values in exports and imports.

منتشرشده در ۱ فروردین ۱۴۰۴ · Table

CSV cannot distinguish NULL from empty string without side metadata, both often appear as consecutive commas. Warehouses and ORMs apply different defaults on load.

Conventions

  • Document whether "N/A", "null", or blanks mean missing.
  • Trim whitespace on ingest when policy allows.
  • Avoid mixing sentinels across feeds for the same column.

← همه مقالات