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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-03 : 10:43:10
|
| Stefan writes "I have a table with an image column. The goal is to can save entire documents (for example .doc) which can contain text and pictures too.On the other side I must have the posibility to interogate this filed with specific phrases (contains, freetext etc.)I asociate to the image column a text filed where I store the field's extension. I realise the full text index to the table and to the column. But the problem is that any query I made get no rows (using contains for example).What is my mistake? How can I interogate these kind os fields. Do you know some better ways for storing this kind of large documents and interogate them?With text fields is ok but in text I cannot strore only text, isn't it?Thank you very much." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-03 : 11:38:08
|
| SQL server doesn't know abou tthe contents of an image field - it's just binary data so you can't do anything with it (except maybe deal with binary strings).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
guxiaobo1982
Starting Member
1 Post |
Posted - 2004-05-04 : 01:06:33
|
| But what if I add a column to indicate the content type of the binary data ,I head about full-text search can do this .Can someone help us?Best thanks! |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-04 : 02:41:21
|
| yes the search engine can do it.You need a bindling column which contains the extension((.doc, .xls, .ppt, .txt, .htm)Have a look at sp_fulltext_column.When you add the column to the index you can specify @type_colname which references the inding column to give the type of the document in the image column.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Manage image data types