| varchar2 [message #372858] |
Wed, 14 March 2001 09:59  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
Where can I find the maximum size allowed information for varchar2. I did read in the manual that it allows 4000 bytes. But some where I also read that in 8.1.7 it allows 32k bytes.
I am confused and I wanted to make sure the exact size it supports.
I appreciate your help.
Regards
Raj
|
|
|
|
| Re: varchar2 [message #372863 is a reply to message #372858] |
Wed, 14 March 2001 15:07  |
Joachim Lindner
Messages: 30
Registered: February 2001
|
Member |
|
|
Some time ago I learned that the maximum number of characters you can store in a varchar2 column in an Oracle 8.x.y database table is 4000.
However, in a PL/SQL context the a varchar2 type variable can store up to 32K characters.
|
|
|
|
| Re: varchar2 [message #372866 is a reply to message #372863] |
Wed, 14 March 2001 15:13 |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
That means in my servlet/perl cgi script can I insert data of size 32k into a varchar2 datatype.
Thanx
Raj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
