Change Clob To ????

Hi all,

I have a table and this table had 20 columns, there were 5 columns that had datatype is CLOB and this won't work for our web application. What is the datatype should I change it to ??? One column had more than 5000 characters and the other 4 I can user VARCHAR2.

Please help

Ur problem, i gess, not in type of a column.
U have problem in client side of application.

What web application server u are using?
What language and driver is using?

U have to find decision on client side.

We have many applications with CLOB/BLOB fields in web envifonment,
and we haven't any problems with this type of field.

I read somewhere before and from what I understand that CLOB will degrade performance of your database.

Is that right to say ???

Quote:

---

Originally posted by mike2000
I read somewhere before and from what I understand that CLOB will degrade performance of your database.

---

I've never seen that CLOB itself degrades performance.
Application using CLOBs in an improper way could do that, though.