Data type [message #373618] |
Fri, 27 April 2001 00:51 |
T.Swaminathan
Messages: 1 Registered: April 2001
|
Junior Member |
|
|
Actually i want to store a HTML page in VARCHAR2 data type. I cannot store the whole HTML page in this data type. How many characters can i store in a VARCHAR2 data type ? . When i refer some books they said we can store upto 4000 bytes, but i cant store that much.so i want to know how many characters can i store in a VARCHAR2 data type. And give me suggestion which data type can i use for the above problem
Thank you
|
|
|
Re: Data type [message #373650 is a reply to message #373618] |
Mon, 30 April 2001 04:46 |
lp
Messages: 8 Registered: April 2001
|
Junior Member |
|
|
VARCHAR2 range is 1..32767. So you can declare a variable of type VARCHAR2 to store upto 32767 characters.
For your problem you could go up by having a column declared as LONG and store your HTML page in it.
|
|
|