I got a pulzzed issue on using bteq to import data from data files into a Teradata table. My data file has Chinese characters, I run these process on Linux shell environment.
Below is my bteq script: Posting text removed based on formal request from Owner of the associated Intelectual Property
Note: Posting text has been obfuscated due to a formal request by the owner of the Intelectual Property.
On your Create Table, is the server character set UNICODE for the COULMN_NAME_OBFUSCATED Using field?
Note: Posting text has been removed or severly obfuscated based on formal request from Owner of the associated Intelectual Property
Yes, COLUMN_NAME_OBFUSCATED field is UNICODE, the following is my table's DDL:
CREATE SET TABLE TABLE_NAME_OBFUSCATED ,NO FALLBACK ,
PRIMARY INDEX ( INTELECTUAL_PROPERTY_REMOVED );
I have also try to set BTEQ session charset and input/output charset to both UTF8, but this issue is still the same.