Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016