i am using oracle db
i have used varchar2 datatypes to store long text descriptions but it i now need more charachers than the allowed limit. i changed the datatype from varchar2 to blob but my application now doesnt work.
my question is what datatype should i use to store strings longer than 4000 charachers (varchar2 limit). is blob the way to go? and if yes why doesnt my application work since i changed to blob
thanks in advance for your help
(...cause i m stuck!)