Page 1 of 1
Datastage Error
Posted: Thu Feb 21, 2008 1:05 am
by naveen19
Hi Folks,
i having problem in loading the data into the Oracle database
and i am getting new error...if any body having any idea please share it
main_program: Invalid character(s) ([xCD]) found converting string (code point(s):
VALUE[x00][xCD][x09] [x00]) from codepage UTF-8 to Unicode, substituting.
Thanks in Advance
Regards..Naveen.K[/img]
Posted: Thu Feb 21, 2008 1:38 am
by ray.wurlod
Study the error message - get everything you can out of it. For example, what are these characters, and why can't they be converted?
Posted: Thu Feb 21, 2008 4:20 am
by naveen19
ray.wurlod wrote:Study the error message - get everything you can out of it. For example, what are these characters, and why can't they be converted? ...
Thanks Ray...
For your guidence
i will do that..once i get the result i will post the result...
Regards..Naveen.K
UNICODE in Column Definition
Posted: Thu Oct 02, 2008 9:03 pm
by FDW_CITI
Can anyone explains what this UNICODE signifies in column definitions.
We have defined the NLS Lang as UTF8 and all column datatype is VARCHAR2. We are using Oracle database for loading the data
Do we need to define the extended type as UNICODE?
Regards,
Manju
Posted: Thu Oct 02, 2008 9:24 pm
by ray.wurlod
Welcome aboard.
We do not hijack threads with questions irrelevant to the thread.
Please post a new topic with this question.
Posted: Thu Oct 02, 2008 9:26 pm
by trokosz
Well setting NLS_LANG is one thing but have you set utf8 in the dsenv? have you set the NLS to utf8 in the DS Admin GUI so all JObs and Stages understand there defaults?
Posted: Thu Oct 02, 2008 11:43 pm
by FDW_CITI
Yes, it is set ...
Please respond to my new post with subject "UNICODE for CHAR/ VARCHAR2 columns"