LANG Environment variable
Posted: Tue Mar 15, 2011 1:42 am
Hello all.
I have a process where i pick data from tables, process them and create files.
When i run the process in produciton, i got the warning "Invalid character(s) ([x8000]) found converting Unicode string (code point(s): 2.00[x0002]0[x0080][x8000]3619108.3619114.715535.2056639.3919244.2056615.11202413.10971540[x0006]FOG[x000E]860...) to codepage ISO-8859-1, substituting.".
But when i run the same process in development, i do not get this error. In Development and production i was extracting the data from same table.
Later i checked the environment variables list and i found "LANG=en_US.UTF-8" variable on devlopment job log but not in the log of production process. Is this the culprit.
But when i go into linux environment and type "echo $LANG", i get "LANG=en_US.UTF-8" in production too. But i cannot see this in Job log ( Director). Is this environment varaiable not being respected by Production DataStage server. Please help me out.
I have a process where i pick data from tables, process them and create files.
When i run the process in produciton, i got the warning "Invalid character(s) ([x8000]) found converting Unicode string (code point(s): 2.00[x0002]0[x0080][x8000]3619108.3619114.715535.2056639.3919244.2056615.11202413.10971540[x0006]FOG[x000E]860...) to codepage ISO-8859-1, substituting.".
But when i run the same process in development, i do not get this error. In Development and production i was extracting the data from same table.
Later i checked the environment variables list and i found "LANG=en_US.UTF-8" variable on devlopment job log but not in the log of production process. Is this the culprit.
But when i go into linux environment and type "echo $LANG", i get "LANG=en_US.UTF-8" in production too. But i cannot see this in Job log ( Director). Is this environment varaiable not being respected by Production DataStage server. Please help me out.