Re: sql loader size constraint in oracle 8

Alex Landsman wrote:
> Thanks for the replies.
> I did a search on google and there are some pages that claim 2000 chars is
> the limit for a varchar2 in 8i and others that claim its 4000 chars. On my
> version of Oracle it is definitely 4000 chars, so that isn't an issue. I did
> come up with a couple of work arounds for my problem for anyone who is
> interested;

Both could be correct, as the limit is 4000 *byte* - which may be equivalent to 4000 characters in a single-byte character set, or *less* than 2000, in a multi-byte character set.

-- 
Regards,
Frank van Bortel