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 Quote 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. Quote 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 Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.