mits 0 Posted April 12, 2011 Share Posted April 12, 2011 I'm a little confused here. I have 3 fields in my table which require long text to be entered so the standard varchar2 isn't enough. I tried the "LONG" data type but it errored saying a table can only have 1 LONG data type used. Which data type do i use to cater for text for more than one column? thanks Link to post Share on other sites
Pikachu2000 121 Posted April 12, 2011 Share Posted April 12, 2011 It looks like LONG is deprecated anyhow. Oracle data types. Link to post Share on other sites
mits 0 Posted April 12, 2011 Author Share Posted April 12, 2011 i guess clob is the one for long text then Link to post Share on other sites
Adam 73 Posted April 13, 2011 Share Posted April 13, 2011 It depends on what the text contains- if it's literally text/characters, then use a CLOB - character long object. If it's to store "files", like image data, then you should use a BLOB - binary large object. Both are really fun to work with anyway! Link to post Share on other sites
Recommended Posts
Archived
This topic is now archived and is closed to further replies.