ntext vs. text

Results 1 to 2 of 2

Thread: ntext vs. text

  1. #1
    Join Date
    Dec 1969

    Default ntext vs. text

    Can someone tell me (or point me to a Sequel Server datatype reference) the difference between both ntext and text, and nvarchar and varchar in MS Sequel server? Like what the advantages to using one of the other would be, if any? Thanks guys.

  2. #2
    Join Date
    Dec 1969

    Default RE: ntext vs. text

    Right out of a SQL Server programming book,<BR><BR>ntext<BR>- Variable length unicode character data, maximum of 1,073,741,823 characters.<BR><BR>text<BR>- Maximum length is 2,147,483,647 characters. Data is non-Unicode.<BR><BR>varchar<BR>- Variable length characters data. Values are not padded with spaces (like char). Data is non-unicode and maximum length is 8,000 characters.<BR><BR>nvarchar<BR>- Variable length Unicode character data. Values are not padded. Maximum length is 4,000 characters.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts