Funny characters in Fastexport script...Please suggest...

Tools & Utilities

Funny characters in Fastexport script...Please suggest...

Hi,

I am trying to export customer names whcih are in chinese characters using fastexport.
But all the chinese characters are coming in some funny characters in the export file.
Please suggest me some solutions.......

simple fastexport:

select

||(coalesce(trim(cast( CUST_NAME AS CHAR(100))),'NULL'))||'|'

from customer;

In table declaration:

CUST_NAME VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC,

Srini.
2 REPLIES
Teradata Employee

Re: Funny characters in Fastexport script...Please suggest...

You need to specify a client characterset for the output data, e.g. "-c UTF16". The default is ASCII (or EBCDIC for mainframe).

Re: Funny characters in Fastexport script...Please suggest...

Thanks a lot. It is working now.........