Solved

Need a replacement data type in Oracle

Posted on 2016-11-23
6
31 Views
Last Modified: 2016-11-23
I have a couple of tables in a database that are using the LONG data type. It's a horrible data type and we need to get rid of it. The question is what do I replace it with? I've narrowed it down to LOB, BLOB, or CLOB but the differences between those seem subtle and I can't quite figure out which is the best choice and why. Some of the LONG fields are storing bitmap image data. Others are storing HTML markup text. I'm OK with using a different data type for each of those. I just need to get rid of the LONG.
0
Comment
Question by:Russ Suter
  • 3
  • 2
6 Comments
 
LVL 34

Accepted Solution

by:
johnsone earned 500 total points
ID: 41899757
LONG data types are actually no longer supported.  I believe that support for them was dropped in Oracle 9.

For character data (like HTML) use CLOB.
For binary data (like images) use BLOB.

LOB is just a general term for both of them.
0
 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 41899758
For bitmap image data, you have to use a: BLOB (short for Binary Large OBjects).  For html data, you can use a: CLOB (short for Character Large OBjects).  I think a LOB is just a newer replacement for LONG, but still ambiguous, since it can contain either binary or character data.
0
 
LVL 20

Author Comment

by:Russ Suter
ID: 41899760
That's basically what I thought. Is there any reason why I can't use a BLOB to store the HTML data also?
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 34

Expert Comment

by:johnsone
ID: 41899763
There is no reason you cannot store HTML in a BLOB.  CLOB has more features (like you can do substrings and things like that).
0
 
LVL 20

Author Comment

by:Russ Suter
ID: 41899767
That's good to know. Obviously we're not using substrings and things like that with the LONG data type so it sounds like we won't be missing anything by just using BLOB.
0
 
LVL 34

Expert Comment

by:johnsone
ID: 41899770
You probably wouldn't be missing anything, but it allows you do do more things without having to convert it later.
1

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now