Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
saikrishna
Participant
Posts: 158 Joined: Tue Mar 15, 2005 3:16 am
Post
by saikrishna » Tue Oct 14, 2008 1:17 am
Hi
We are changing our Character set to UTF-8 in our Oracle database. We are doing this to load some special characters to our changed database.
To change in ETL front, we have hundreds of jobs which does loading. All are assigned to Project default.
The project default in administrator is "ISO8859-1". Can we change project default to "UTF-8" to apply change in all the jobs of the project?
Please suggest the solution.
Also, Oracle's UTF-8 is same as DataStage UTF-8?
Thanks
Sai
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Oct 14, 2008 2:08 am
You can change the default for a project using the Administrator client.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
saikrishna
Participant
Posts: 158 Joined: Tue Mar 15, 2005 3:16 am
Post
by saikrishna » Tue Oct 14, 2008 3:08 am
Thanks ray
Can you please tell me whether NLS character set UTF-8 would be the correct mapping, if we have UTF-8 in the database, is it correct?
Thanks
Sai
Nripendra Chand
Premium Member
Posts: 196 Joined: Tue Nov 23, 2004 11:50 pm
Location: Sydney (Australia)
Post
by Nripendra Chand » Tue Oct 14, 2008 4:02 am
In case of Oracle database you need to specify NLS_LANG (environment variable) value also. for example you can set the value of NLS_LANG as 'AMERICAN_AMERICA.UTF8'.
-Nripendra Chand
saikrishna
Participant
Posts: 158 Joined: Tue Mar 15, 2005 3:16 am
Post
by saikrishna » Tue Oct 14, 2008 5:21 am
I was asking whether UTF-8 in DataStage is equivalent to UTF-8 in database?
Thanks
Sai
Nripendra Chand
Premium Member
Posts: 196 Joined: Tue Nov 23, 2004 11:50 pm
Location: Sydney (Australia)
Post
by Nripendra Chand » Tue Oct 14, 2008 5:45 am
UTF8 is character encoding in which one character can have multiple bytes. what do you mean by equivalence here? Obviously the values in datastage and database will be same for any UTF8 character if both support Unicode.
-Nripendra Chand
saikrishna
Participant
Posts: 158 Joined: Tue Mar 15, 2005 3:16 am
Post
by saikrishna » Tue Oct 14, 2008 6:40 am
Thanks Nripendra
I mean the same..
I wanted to just confirm on which NLS mapping should be applied in DataStage, when database is set to UTF-8.
I got the answer.
Thanks
Sai