Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2008 @ 18:43:56 GMT

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

Hi,

Does anyone have some insight into the working of Unicode in combination with FastExport?

Due to problems with exporting a Unicode table, I specified FEXP to export the data as UTF8.

(calling FEXP I specified "UTF8")

The result file is indeed UTF8 and looks good; But I'm having problems with the FEXP script I'm using.

Previously I used the '' (alt 0172) symbol to separate the columns in the output.

With the UTF8 specification, I get an error from FastExport;

     "UTY8713 RDBMS failure, 6705: An illegally formed character string was
           encountered during translation."

What I used to do:

     Select col1 (char(10)),
              ''    (char(1)),
              col2 (char(10))

      from MyTable
      ;

Replacing the symbol with a pipe '|' solves this error, but I'd like to keep the old symbol.

We already tried the HEX code for this symbol ('AC'xc) which does turn up the symbol, but also adds some other garbage in the file.

So I'd rather not use the HEX code...

Regards,

Menno van Tienhoven

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