Post reply

blob and images

  • December 9, 2003 at 2:58 pm

    #81692

    How to see real photos from Northwind..Employees tables in Win2k SQL2k?

  • December 9, 2003 at 3:25 pm

    #485437

    Frank Kalis would recommend you read this

    Frank are you there?


    * Noel

  • December 10, 2003 at 2:57 am

    #485487

    Surely.

    Yesterday evening I decided to write something on binary data and SQL Server. This way I don't need to generate traffic on the MS site, but rather here

    Andy, what do you think?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 10, 2003 at 2:48 pm

    #485614

    Thanks for replies, but my question was: How can I see real pictures directly in sql QA as we can see them in MS Access, how to insert real .jpg files in sql table using sql tools.

  • December 11, 2003 at 2:26 am

    #485670

    You cannot.

    QA is a text based tool. It's unable to interpret the flow of bits of an image.

    You need a client tool beeng able to anderstand the fotrmat of the image/doc.

    Bye

    Gabor



    Bye
    Gabor

  • December 11, 2003 at 1:28 pm

    #485826

    Yes, Gabor is right.

    Access uses a data type named 'OLE something',which also interprets the stored data.

    However you'll notice that this sometimes nice feature has its price in a massive storage overhead. While data stored in an image column in SQL Server is roughtly the same as the original file has, Access blows the size to an unmanageable amount.

    I once had tried this and stored some 20MB of pics into Access.

    IIRC the mdb had after this a size of about ~100MB.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 6 posts - 1 through 6 (of 6 total)

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