Dear All,
We have been using telerik controls in various projects. Currently we have
encountered an issue with the RadUpload control.
The issue is how the RadUpload control reads and saves the file data in the
database.
We have uploaded a word document with both .doc and .docx extension.
It saves the file in the database. When we do a free text search in the SQL server
it only searches a word document with .doc extension.
It does not search the word document with .docx extension.
See the below SQL script we have used to search for the data in the file:
Select * from tblDocuments
where
FREETEXT(tblDocuments.FileData, 'words to search')
It searches the FileData column in the tblDocuments table
The datatype of FileData column is varbinary(MAX)
if we upload a .docx via the file system (save to disk and then upload from disk to database)
the freetext search searches the .docx file. But if we use RadUpload control it does not search the .docx file.
It could be the way the RadUpload control creates a stream object to read the filedata.
Could you please look into this issue?
Please let us know if you need any more information with regards to this issue.
Thanks.