Re: Custom types / "long" datatypes in custom functions

> 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[]?

dave