SQL Server Performance Forum – Threads Archive

Int type in full text indexing

Hi All,
How can we use the int type column in full text indexing? Regards
Ashish Kuriyal

---

hi,
why u want to enable full text index on a integer column. Only columns of type char, varchar, nchar, nvarchar, text, ntext, image, xml, and varbinary can be indexed for full-text search. Refer this link :http://msdn2.microsoft.com/en-US/library/ms187317.aspx Madhu

---

Thanks for knowledge but I already know that full text indexing can be used only on these datatypes. But what if the datatype is int and want to use in full text indexing for some combination with other varchar datatype col.
Might be the requirement.

---

Is there no alternate to accomplish this task?

---

Is this related to SQL 2005 installation? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

No, its related to full text indexing on int datatype of SQL Server 2005 Database.

---

]]>