Skip to content

TSV smart quote behavior

David An edited this page Nov 16, 2022 · 1 revision

This page shows how various TSVs are interpreted, specifically focusing on handling of smart quotes.


sys_name	mycolumn
11111111	"hello"

Creates a value in mycolumn (all equal):

  • WDS with smart-quote replacement: scalar hello
  • WDS without smart-quote replacement: scalar hello
  • Entity Service: scalar hello

sys_name	mycolumn
11111111	“hello“

Creates a value in mycolumn (all equal):

  • WDS with smart-quote replacement: scalar “hello“
  • WDS without smart-quote replacement: scalar “hello“
  • Entity Service: scalar “hello“

sys_name	mycolumn
11111111	I said “hello“ first

Creates a value in mycolumn (all equal):

  • WDS with smart-quote replacement: scalar I said “hello“ first
  • WDS without smart-quote replacement: scalar I said “hello“ first
  • Entity Service: scalar I said “hello“ first

sys_name	mycolumn
11111111	["hello","world"]

Creates a value in mycolumn (all equal):

  • WDS with smart-quote replacement: array hello, world
  • WDS without smart-quote replacement: array hello, world
  • Entity Service: array hello, world

sys_name	mycolumn
11111111	[“hello“, “world“]

Creates a value in mycolumn (behavior differs):

  • WDS with smart-quote replacement: array hello, world
  • WDS without smart-quote replacement: scalar [“hello“, “world“]
  • Entity Service: scalar [“hello“, “world“]

sys_name	mycolumn
11111111	["I said “hello“", "You said “world“"]

Creates a value in mycolumn (behavior differs):

  • WDS with smart-quote replacement: scalar [\"I said “hello“\", \"You said “world“\"]
  • WDS without smart-quote replacement: array I said “hello“, You said “world“
  • Entity Service: array I said “hello“, You said “world“