mits 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 comment https://forums.phpfreaks.com/topic/233484-oracle-data-type-for-long-text/ Share on other sites More sharing options...
Pikachu2000 Posted April 12, 2011 Share Posted April 12, 2011 It looks like LONG is deprecated anyhow. Oracle data types. Link to comment https://forums.phpfreaks.com/topic/233484-oracle-data-type-for-long-text/#findComment-1200605 Share on other sites More sharing options...
mits Posted April 12, 2011 Author Share Posted April 12, 2011 i guess clob is the one for long text then Link to comment https://forums.phpfreaks.com/topic/233484-oracle-data-type-for-long-text/#findComment-1200609 Share on other sites More sharing options...
Adam 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 comment https://forums.phpfreaks.com/topic/233484-oracle-data-type-for-long-text/#findComment-1201057 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.