MS SQLServer &PG: "Text"
Posted: Fri Jul 16, 2021 1:51 pm
Guys,
in the past i read about the column-datatype "text" in Postgres (similiar to our trusty "Memo") and about the interesting fact, that is rather faster than varchar etc.
Now, i stumbled about the same problem in MS Sql, found in the docs (2017) they have "text" - but it is marked a obsolete and to be removed in "future versions". Searched further, and the first result seems to be, there's no replacement. And, further on, "(beyond the usual warning that the maximum row size exceeds the allowed maximum of 8,060 bytes)". Is that all true?
No need for debate about smart schema design etc, i need only some ammunition for debate with supplier
in the past i read about the column-datatype "text" in Postgres (similiar to our trusty "Memo") and about the interesting fact, that is rather faster than varchar etc.
Now, i stumbled about the same problem in MS Sql, found in the docs (2017) they have "text" - but it is marked a obsolete and to be removed in "future versions". Searched further, and the first result seems to be, there's no replacement. And, further on, "(beyond the usual warning that the maximum row size exceeds the allowed maximum of 8,060 bytes)". Is that all true?
No need for debate about smart schema design etc, i need only some ammunition for debate with supplier