Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Unanswered: inserting icons in table

    i've got a table with a column Picture as Image

    can I insert icons in that column ?

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    One of ways to import image file:

    create table bimage (picture image)
    go
    BULK INSERT bimage FROM 'c:\temp\image8K.bmp'
    WITH (
    FORMATFILE = 'c:\temp\image8K.fmt'
    )

    image8K.fmt file(where 7974 is size in bytes):
    8.0
    1
    1 SQLIMAGE 0 7974 "" 1 picture Latin1_General_BIN

  3. #3
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    1) Is it tha same format file for .ICO
    2) Where do I find the Image8K file

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Originally posted by Karolyn
    1) Is it tha same format file for .ICO
    2) Where do I find the Image8K file
    image8K.bmp is name of file what has to be imported on server. You can type name of your file.
    See BOL for details.

  5. #5
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    8.0
    1
    1 SQLIMAGE 0 7974 "" 1 picture Latin1_General_BIN



    doesn't work :

    Latin1_General_BIN is not a valid classification ("Classement")
    for bmp or ico files


    I'm looking for other classification names

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •