On 4/28/06, Jun Li <[EMAIL PROTECTED]> wrote:
JDBC type LONGVARCHAR or OTHER could be varchar2 or nvarchar2 on Oracle 9i, but it mapped into CLOB or BLOB.
No, they can't. nvarchar2 has a limit of 4000 bytes in Oracle 8i, and in 9/10 the limit should be around the same number. LONGVARCHAR however can - per JDBC doc (http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/getstart/mapping.html#996857) - have lengths of 1G or more. Similarily, OTHER is not constrained by JDBC and thus can only be safely be mapped to a large binary type. Tom
