.csv

Search services

Search tools and open pages quickly

Οδηγός προϊόντος · 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.

Δημοσιεύτηκε 21 Μαρτίου 2025 · 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.

← Όλα τα άρθρα

Χρησιμοποιείται από κορυφαίες ομάδες

Λογότυπα σε κύλιση (κάθε σύνδεσμος ανοίγει τον ιστότοπο της μάρκας): Google, Apple, Meta, GitHub, Stripe, Shopify, Databricks, Snowflake, Notion, Vercel, Intel, NVIDIA, Netflix, Spotify, Airbnb, Yale, Harvard University, Massachusetts Institute of Technology, Stanford University, University of California, Berkeley, Princeton University, California Institute of Technology, Columbia University, University of Chicago, Cornell University, Duke University, Carnegie Mellon University, Georgia Institute of Technology, Johns Hopkins University, Northwestern University, University of Toronto, McGill University, University of Oxford, University of Cambridge, Imperial College London, University College London, ETH Zurich, EPFL, Technical University of Munich, Sorbonne University, KU Leuven, National University of Singapore, Nanyang Technological University, Tsinghua University, Peking University, The University of Tokyo, KAIST, Seoul National University, University of Melbourne, Australian National University, University of Sydney, The University of Hong Kong.