Archives of the TeradataForum
Message Posted: Wed, 01 Nov 2006 @ 14:49:18 GMT
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|