제품 가이드 · 약 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.
게시 2025년 3월 21일 · 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.