473,386 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

blob and clob

Hello everybody,

Could u please tell me the when we should use blob and when to adopt clob???

I read in the previous posts about storing files in the databse. The 2 methods mentioned were storing the file path in the database while the other being using the blob datatype. For a medium scale application which is better. Will there be performance issues?
Also do i need to do anything different when i am storing pictures and documents to the database?

Thanks
Gunjan
Sep 21 '08 #1
0 2502

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Stanley Sinclair | last post by:
(Minor question. Since updating to FP4 I cannot access HTML help. Compiler error. What's wrong?) _______________________ Subject of this message: There is lots of Help regarding getting...
2
by: Martin Wingelaar | last post by:
I would like to play around with BLOB and CLOB's and need the sample programs compiled by DSNTEJ71, DSNTEJ73 and DSNTEJ75. The problem is I don't have a C/C++ compiler. Could anyone send me the...
0
by: Martin | last post by:
Hi, does anybody know whether it is possible in C application (using CLI) to have multi-row parameter descriptor with column of LOB type (BLOB, CLOB, DBCLOB) whose data will be supplied at...
4
by: Nina via DBMonster.com | last post by:
Hi, I'm trying to insert a clob / blob from the local file system into a basic table. This can be quite easily accomplished in Oracle but I have not found any wquivalent way on how to do this in...
2
by: C Glenn | last post by:
What DataType should I use for a field that is BLOB SUBTYPE TEXT on the backend? I've tried String and Char. I'm getting a runtime error telling me that the SourceColumn is a Char. Thanks.
2
by: deepgun74 | last post by:
I have a blob column that is 4MB in length. I need to change it to store a 3GIG binary. 1) What is the maximum size a BLOB column can support? 2) How do i alter the size of an existing BLOB...
0
by: yoyo | last post by:
DOes anybody have a working example of how do make this work? I've tried everything I could find, Clara patch, many non-working examples using pack, baseencode, addslashes, str_replace, bin2hex,...
1
by: msc.batra | last post by:
I want to load multiple rows of BLOB and CLOB into DB2 using CLI. Which are the possible ways to do it? Any help...
6
by: okonita | last post by:
Hi all, I have a table define as: col1 int col2 BLOB col3 TIMESTAMP I have several JPEG,GIF, etc photos...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.