Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Since Text and NText are being deprecated, what is the best data type to use for a Full text Index ? Expand / Collapse
Author
Message
Posted Tuesday, September 17, 2013 10:14 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, July 19, 2014 9:15 PM
Points: 537, Visits: 1,110
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
Post #1495573
Posted Tuesday, September 17, 2013 3:42 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:24 PM
Points: 805, Visits: 722
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).

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1495704
Posted Wednesday, September 18, 2013 5:07 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, July 19, 2014 9:15 PM
Points: 537, Visits: 1,110
Thanks!
Post #1495847
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse