Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Provided Answers: 4

    Unanswered: BLOB, CLOB, DBCLOB, what to use ?

    We must be able to store and retrieve ALL the documents (PDF, Word .doc, ASCII, .RTF, XML, HTML, ...) our application generates.

    - What is the best data type to store these documents in? BLOB, CLOB, DBCLOB ?
    - How does one store/retrieve a Java object in/from a xLOB ?

    Any references, comments, ... are very much appreciated.
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  2. #2
    Join Date
    Mar 2004
    Toronto, ON, Canada
    I would imagine you're looking for a BLOB for most of those, since you're dealing with binary data. ie. PDF, Word.

    However, if you chose BLOB then be aware that for your non-binary files (ie. HTML, .txt) there will be no codepage conversion. What you INSERT is what will be there.

    There are examples of accessing CLOB/BLOB/etc in sqllib/samples/java, they're as good as anything I could post for you here so check them out first, and ask any questions you might have about them.
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Nov 2004


    probably a blob to keep any type of document
    for references see :
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

Posting Permissions

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