Problem in Loading Special Characters into Oracle 8i

Hi All,

I m facing problem in inserting the special characters present in greek language to the oracle database. The source is the flat file and the target is the database. I m using informatica 5.1 to load the data from flat file to the database. The nls_characterset=UTF8 in the database.

The input greek characters are:

Ÿƒ†ƒ„Ž‡„Ž���‰

Ισλαικό Ίδρυα



These are stored in the target database as follows:

?????????¿¿¿?

??????? ?????



Could you please help me in solving this problem.



Note : Even if I try to insert manually into the database, its giving the same problem.

I tried with nls_characterset=al32UTF8 in the database also. I am facing the same problem here also.

The data is getting loaded from flat file to flat file properly

Any help is appreciated.
Thanks,
Pramod

The character set settings in the database is not the only relevant thing You need to set the client character set as well. Either by setting the NLS_LANG environment variable or modifying the approriate registry entry

Apart from that I would make sure that your tool really supports UTF8 or maybe needs some special setting as well.

You can also try SQL Loader which supports UTF8 for flat files (again the client character set setting is important)

Hi Shammat,

We have changed the NLS Lang variable to AMERICAN in the database as well as in the client.

Regarding the tool when we load the data from flat file to flat file it loads in the correct format.