Archives of the TeradataForum

Message Posted: Wed, 01 Nov 2006 @ 14:49:18 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

We're having problems in loading UTF-8 data which has been exported from Oracle (taken from a Linux server), ftp'd across to a Linux application server and then attempted to Fastload into a table (defined with Unicode columns).

The separator we've been using is the Logical Not '?' but, having read the manual, we now believe we have to use a single byte character, not double byte (as the '?' is seen to be in Linux).

However, we've got all sorts of characters coming through from certain input free-format text fields, so the choice of separator is somewhat limited.

We'd rather not have to convert the process to fixed position data, so I was wondering what you guys either do or would recommend.

Sadly, what Fastload does not have - which Oracle's SqlLoader does have - is the option of defining input fields as Optionally Enclosed by " ", which would have made it all very nice.

What we infer from our experience and what we read is that, whilst Fastload can certainly accommodate UTF-8 data, it cannot use anything other than standard single byte delimiters.

Anyone know how to get out of this conundrum ?

Thanks,

Dave Clough
Database Designer
Express ICS

www.tnt.com

	<Prev	Next>		<<First	<Prev	Next>	Last>>