Results 1 to 6 of 6

Thread: TXT vs BLOB

  1. #1
    Join Date
    Mar 2003
    Location
    WA State
    Posts
    3

    TXT vs BLOB

    I noticed in a post somewhere in the manual that someone recommended to someone else that they should use text type col instead of a blob.
    I am just starting to put together a newsletter and would like to put the articles into the db.
    Could someone expound on the text vs blob thing for me before I commit.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    I don't think you can put a binary data in text column. Text column supposed to have readable text.

    Just my 2 cents

  3. #3
    Join Date
    Mar 2003
    Location
    CA,USA
    Posts
    18

    BLOB vs Text objects

    BLOB represents Binary Large Object while (Oracle) text objects have the datatypes CLOB or LONG.

    you also havea third type BFILE.

    I will not get into a detail level explaination here but the basic difference lies in the fact that you can store data like WORD documents, pictures etc. in BLOB .
    While in CLOB , which is pretty much similiar to LONG , you can store text data.

    Special built-ins are provided by Oracle PL/SQL to initialize, load or acess data in BLOB / BFILE.

    For more deatils , you can go to technet.oracle.com and refer to the LOB related manuals.

    Hope that helps.

    Thanks

  4. #4
    Join Date
    Mar 2003
    Location
    WA State
    Posts
    3
    So then if my articles have lots of references that contain numbers such as 3:5 or 1,3:5 I should use blob not text columns.

    The articles will have bibical references such as Rom 1:1 or Gen 20:3-5

    So should I BLOB or not?

    Thanks
    Paul
    Last edited by pgriff; 03-18-2003 at 01:17 PM.

  5. #5
    Join Date
    Mar 2003
    Location
    CA,USA
    Posts
    18
    When you mention references, do you imply "Hyper Links"?

    Is so, then i presume you are useing word documents.

    In such , you have (in Oracle ) 2 options
    1) BLOB-- data stored in the database.
    2) BFILE-- a file locator-- Files
    stored externally but
    pointers maintained in the
    database.

    The data in CLOB should be TEXT. JUST TEXT. Period!

    -HTH

  6. #6
    Join Date
    Mar 2003
    Location
    WA State
    Posts
    3
    That's what happens when two different fields of research collide, I meant Biblical references not data references.
    Sorry about that.

    I believe that from what I am reading in a MySql database setting the column that will contain articles with numbers as described above would be better served by using a blob type.

    The final product will be a newletter that will call the db by PHP.

    You help is much appreciated.

Posting Permissions

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