fbpx
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

MS SQLServer &PG: "Text" 16 Jul 2021 15:51 #19108

  • FFF


  • Posts: 1162
  • 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 (X# 2.7; Xide 1.27; W8.1/64 German)

    Please Log in or Create an account to join the conversation.

    MS SQLServer &PG: "Text" 16 Jul 2021 16:10 #19109

    • Jamal


  • Posts: 244
  • Try using NVarChar(MAX).

    Jamal

    Please Log in or Create an account to join the conversation.

    • Page:
    • 1