Column type [message #7433] |
Thu, 12 June 2003 22:15 |
sTe810
Messages: 1 Registered: June 2003
|
Junior Member |
|
|
I know that if I use VARCHAR2 I cannot make the length of a column to be greater than a certain limit (2000?). I want to save some textual information (such as error messages and its stack trace) in one column and it is likely that it gets larger than 2000. What's the next level of datatype that has larger space limit that would be appropriate for me, and what would be some pros and cons of it?
I am new to Oracle... any ideas would help. TIA!
|
|
|
Re: Column type [message #7436 is a reply to message #7433] |
Thu, 12 June 2003 22:58 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
And your Oracle version is...?
Oracle 8i and up allows 4000 bytes in a VARCHAR2. I've never had an error stack come close to that. Above that, you would go to a CLOB (up to 4GB).
|
|
|
Re: Column type [message #7438 is a reply to message #7433] |
Thu, 12 June 2003 23:02 |
Dinesh Babu.R
Messages: 1 Registered: June 2003
|
Junior Member |
|
|
Hi,
In oracle 8i you can store as long as 4000 characters in a column if you want to store more than that you have 2 options
1. create 2 columns of length 4000, this sounds simpler as u need to subtring and insert the varchars in the appropriate columns, so that while retreiving the record it will be easy (need to add like col1 || col2 )
2. to use BLOB data type in oracle
Thanks
Dinesh Babu.R
|
|
|