my question is what datatype should i use to store strings longer than 4000 charachers (varchar2 limit) in oracle. is LONG the best datatype to use?
Hi,
I think LONG is the only choice in that case. Use LONG for strings>4000 characters and one of the BLOB types for binary data.
Thomas
i thought that would be a good way to do it but it seems that LONG is depreciated...Is LONG supported in oracle 9i?
Yes,
LONG is deprecated but Oracle9i still supports that type. The better choice with Oracle9i is CLOB (or NCLOB for multi-byte characters).
thanks for your reply
I have tested with CLOBs but wasnt able to retrieve that data using php...
there is an example here showing how to use CLOBs with PHP (oci functions, Oracle9i). Seems like PHP 4.x doesn't support NCLOBS or NCHAR but CLOB should work.
