Managing image data types

• Stefan Ardeleanu

  Mr or Mrs. 500

  Points: 501

  More actions

  April 26, 2004 at 1:39 am

  #162409

  I tried to import with DTS an Oracle database to a SQL Server database.

  I realise this task with one single, but important, exception.

  It exists a BLOB field in a table.

  I consider that it's corespondent in a SQL Server database is image.

  But when I tried to import it was imposible.

  How can I manage image types because it seams to be the only type compatible with oracle blob types.

  On the other side I notices that I can not use full text searvhes on image types. Is there anybody who can advice hoew can I manage these image data types. It seams that only the application can help because SQL Server is not very useful in managing image data types.

  Thanks'

• Coach James

  Ten Centuries

  Points: 1272

  More actions

  April 27, 2004 at 7:27 pm

  #504408

  /* CODE BETTER, FUNCTION BETTER */

  -- Your code should read like it runs

  -- You are correct the (Blob) is binary Image type

  -- I use Server.CreateObject("adodb.recordset")

  -- to move Image data into the SQL database

  -- using a SaveAsBlob method from FileManager

  -- not big w/DTS, but you should find syntax

  -- which provides the correct prepare method

  -- what I do know is that the binary file needs

  -- a pointer within your database, which is used

  -- to read the binary disk data and transport it

  -- to the database disk area. The database retains

  -- a pointer to read the image from disk till end

  -- of file pointer is reached, (ha like varchar?)

  ---

  Regards,

  Coach James

• Stefan Ardeleanu

  Mr or Mrs. 500

  Points: 501

  More actions

  April 28, 2004 at 12:35 am

  #504434

  The problem remains is the query of image data types.

  I made a full text index over this image column in conjunction with a string column which retains the file extension (it may be .doc for example).

  The full text index was populated and I try to query data from that column using contains for example (in BOoks ONline says it must work).

  But my problem is that any query I  make get no results.

  If you were working with full text search using image data types please give me an advice. Mabe I made some mistakes I don't know. 

  For example I've got  a table Table_1 with a column _Image which contains the text 'Test'. The column _Image is asasociated with a column _Extension varchar(10) which store the value doc (i tried with .doc also)

  If I realise the query

  select * from Table_1 where contains (_Image , 'Test')

  I get no results although the full text index exists on column _Image and this habve document type column the column _Extension.

  Thanks'