Post reply

Managing image data types

  • 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'

  • 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

  • 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'

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply