Applying UTF-8 to all jobs of project

saikrishna · 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 · Post by **ray.wurlod** » Tue Oct 14, 2008 2:08 am

You can change the default for a project using the Administrator client.

saikrishna · 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 · 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'.

saikrishna · 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 · 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.

saikrishna · 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