Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_user_2009
Starting Member
2 Posts |
 Posted - 2009-10-08 : 14:24:00
|
| We have .NET code to upload various document types into a VARBINARY(MAX) field in sql server 2005.We also have Full text search set up to search this field. And we have the noiseENU file empty so that no characters/words are excluded from the search.The problem is with uploaded Excel files. If the excel file contains numbers in the cells, and I search for these numbers, these records are not returned. If I convert the cell data types to "General" or "Text" in excel, they still don't return the records. If the numbers are in double quotes "", then it works.For example, the excel file contains "2009" in any of the cells (includes the quotes), then a FTS search will find 2009.If I don't have the quotes, FTS does not find 2009.For other document types like doc,txt,xml, the number search works.Any help is appreciated.Thanks! |
|
|
sql_user_2009
Starting Member
2 Posts |
Posted - 2009-10-15 : 13:31:18
|
I am guessing nobody searches on numbers....? So far no response from anyone. Maybe it's a problem with excel's ifilter? The only way it will work is if I convert excel to another format like xml and then upload the xml document, then it will search. But that is not a solution for my customers....quote:
Originally posted by sql_user_2009
We have .NET code to upload various document types into a VARBINARY(MAX) field in sql server 2005.We also have Full text search set up to search this field. And we have the noiseENU file empty so that no characters/words are excluded from the search.The problem is with uploaded Excel files. If the excel file contains numbers in the cells, and I search for these numbers, these records are not returned. If I convert the cell data types to "General" or "Text" in excel, they still don't return the records. If the numbers are in double quotes "", then it works.For example, the excel file contains "2009" in any of the cells (includes the quotes), then a FTS search will find 2009.If I don't have the quotes, FTS does not find 2009.For other document types like doc,txt,xml, the number search works.Any help is appreciated.Thanks!
|
 |
|
|
|
|
|
|
|
Full Text Search and Excel and Numbers