Re: sqlldr: any way to read unicode data files?

Hi.

In pre-v.9 Oracle versions, varchar2(20) is the placeholder for 20 bytes, not 20 characters. In post-v.9 versions, i think that there is a initialisation parameter for init.ora, that "instructs" Oracle to hold enough space for 20 characters (and not 20 bytes) for a corresponding varchar2(20) field, effectively making this field to be of variable actual size (in bytes).

Regards,
Vasilis

DA Morgan wrote:
>
> Irmen de Jong wrote:
>
> > Is there a way to make sqlldr read and understand unicode data files?
> >
> > I can create such a unicode data file using the bcp.exe tool with the
> > "-w" option, but sqlldr breaks on that with :
> > sql-loader 562: record too big
> >
> > Irmen de Jong
>
> Are you assuming that VARCHAR2(20) means 20 characters rather than 20
> bytes? Or something similar?
>
> Daniel Morgan
Received on Wed Feb 19 2003 - 02:09:49 CST