db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Blasby <dbla...@gmail.com>
Subject Re: Custom types / "long" datatypes in custom functions
Date Tue, 22 Feb 2005 07:26:00 GMT
> Just to be clear functions can send and return non-fixed length data
> types, also known as variable length types. An example is VARCHAR(1000)
> which is a character type whose value can be any length from 0
> characters to 1000 characters. And VARCHAR(1000) FOR BIT DATA is binary
> type whose length can be from 0 bytes to 1000 bytes.

Unfortunately, the maximum size for varchar is only 32k.  Spatial data
is commonly much much larger than this.  "LONG VARCHAR FOR BIT DATA"
would be acceptable for storage, but you are unable to pass this to a
user-defined function (or return one).

Are "VARCHAR FOR BIT DATA" represented by a String type or a byte[]?


View raw message