db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: Wrong type mapping on Oracle.
Date Fri, 28 Apr 2006 08:53:42 GMT
On 4/28/06, Jun Li <allanjunli@gmail.com> 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

Mime
View raw message