Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   FastExport and UTF8 translation of SQL
From:   Tienhoven, Menno van


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...


Menno van Tienhoven

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020