Could you please list what you've tried?anandsivan wrote: We have tried with all options...
Conversion from the UTF-8 character set to UTF-16LE warning
Moderators: chulett, rschirm, roy
Re: Conversion from the UTF-8 character set to UTF-16LE warn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 8
- Joined: Wed Sep 21, 2011 4:27 am
- Location: Karnataka
Yes ... i did this ..but in the job we have date fields if i change UTF8 to UTF-16LE job is aborting because of data fields not converting to UTF-16.ray.wurlod wrote:Have you tried setting NLS mapping to "UTF-16 Little Endian" in DataStage? ...
2) when i change to UTF-16LE job is aborted with below warning:
Output Schema does not match data from SELECT statement SQL statement: SELECT TOP 10 ITEM_NBR ,BASE_DIV_NBR ,MDS_FAM_ID , COUNTRY_CODE FROM WW_CORE_DIM_VM.ITEM_DIM WHERE BASE_DIV_NBR IN (1,18) ORDER BY BASE_DIV_NBR (CC_TeraParallelTransporter::initiate, file CC_TeraParallelTransporter.cpp, line 1,295)
In the teradata table :
COUNTRY_CODE CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('AR','BR','CA','CN','GB','IN','JP','K1','MX','US'),
Because of the country_code only i am getting this warning if i remove country_code job is completing successfully with out warning.
-
- Participant
- Posts: 8
- Joined: Wed Sep 21, 2011 4:27 am
- Location: Karnataka
Re: Conversion from the UTF-8 character set to UTF-16LE warn
Andy,
I have tried below activity's
1) In the datastage i have changed NLS UTF-8 to UTF-16LE
2) Project default map : ISO-8859-1
Transaction mode: ANSI
Client character set : ASCII
Automap characterset encoding: No
NLS map name: ISO-8859-1
3)CC_TERA_USE_ISO88591_ASCII_MAP= 1 at the Project level settings in the Administrator
I have tried below activity's
1) In the datastage i have changed NLS UTF-8 to UTF-16LE
2) Project default map : ISO-8859-1
Transaction mode: ANSI
Client character set : ASCII
Automap characterset encoding: No
NLS map name: ISO-8859-1
3)CC_TERA_USE_ISO88591_ASCII_MAP= 1 at the Project level settings in the Administrator
-
- Participant
- Posts: 8
- Joined: Wed Sep 21, 2011 4:27 am
- Location: Karnataka