Loading special characters in Teradata - Bulk mode
Posted: Tue Jan 29, 2013 3:10 pm
Hello,
I am trying to load data from DB2 into Teradata using Bulk(Fast) method with the connector stage (DS 8.5). If using NLS='window-1252' and Client Character Set='LATIN1252_0A' there are issues with some special characters. '9D' hexadecimal in source ends up being '1A' in Teradata.
Was trying to set Client Character Set to UTF16 but the job aborts. However, setting NLS=UTF-16' for the job and Client Character Set to UTF16 works all right with Immediate method.
Is there any way to make Bulk method loading all possible characters in Teradata?
Thanks,
L.
I am trying to load data from DB2 into Teradata using Bulk(Fast) method with the connector stage (DS 8.5). If using NLS='window-1252' and Client Character Set='LATIN1252_0A' there are issues with some special characters. '9D' hexadecimal in source ends up being '1A' in Teradata.
Was trying to set Client Character Set to UTF16 but the job aborts. However, setting NLS=UTF-16' for the job and Client Character Set to UTF16 works all right with Immediate method.
Is there any way to make Bulk method loading all possible characters in Teradata?
Thanks,
L.