Home » RDBMS Server » Server Administration » Data type
Data type [message #373618] Fri, 27 April 2001 00:51 Go to next message
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 Go to previous message
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.
Previous Topic: illegal relational operator???
Next Topic: where is it?
Goto Forum:
  


Current Time: Sat Jun 29 00:08:06 CDT 2024