Printable View
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:confused:
I don't think you can put a binary data in text column. Text column supposed to have readable text.
Just my 2 cents
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
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:D
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
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.