Post reply

Since Text and NText are being deprecated, what is the best data type to use for a Full text Index ?

  • September 17, 2013 at 10:14 am

    #278018

    I know varchar and nvarchar are the obvious ones, but i have noticed some developers using Varbinary and XML.

    Would there be any advantages in using Varbinary or XML?

    Thanks

  • September 17, 2013 at 3:42 pm

    #1650956

    The answer is that it depends on what you want to index. If you want to index texts stored as such, you use varchar or nvarchar. If you want to index xml documents, you use the xml data type. And if you want to index PDF or Word documents, you use varbinary (and a column which holds the type of the document).

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • September 18, 2013 at 5:07 am

    #1651052

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply