What data type? 1

[calahans]

Hi Guys,

I want to store a string of, lets say, no more than 10,000 chars. Is there a data type, like TEXT, that can accomondate this?

Thanks

Cal Cal

 

[rcurva]

I think you can still safely use VARCHAR2 for your requirement, even if you are using multibyte char set in your database.

Max. size for VARCHAR2 is 32767 bytes.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[sem]

Only pl/sql varchar2 may hold 32K.

To STORE the 10K string value you need CLOB.