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

    Unanswered: format file for ICONS

    I've got this formatfile : Sun.fmt

    8.0
    1
    1 SQLIMAGE 0 8624 "" 1 picture


    When I do :

    BULK INSERT TableImages FROM 'C:\Sun.ico'
    WITH (FORMATFILE = 'C:\Sun.fmt')



    An error occurs and says that the collation-type isn't OK


    What should it be for an icon ?

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Add your collation-type - for instance:

    8.0
    1
    1 SQLIMAGE 0 8624 "" 1 picture Latin1_General_BIN

  3. #3
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    I've tried your Latin1_General_BIN
    it does'nt work for me for .bmp neither .ico

Posting Permissions

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