MS SQLServer &PG: "Text"

This forum is meant for anything you would like to share with other visitors
Post Reply
FFF
Posts: 1521
Joined: Fri Sep 25, 2015 4:52 pm
Location: Germany

MS SQLServer &PG: "Text"

Post by FFF »

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 ;)
Regards
Karl
(on Win8.1/64, Xide32 2.19, X#2.19.0.2.)
Jamal
Posts: 314
Joined: Mon Jul 03, 2017 7:02 pm

MS SQLServer &PG: "Text"

Post by Jamal »

Try using NVarChar(MAX).

Jamal
Post Reply