Hi there.

After our painful experiences with the storage of special characters in the db, this weekend I am altering my database. I am changing it to the we8mswin1252 which supports the euro currency.

An important thing is to first check on the database if the record was stored with the special characters. Use the convert to check this, sometimes it might be stored and not be displayed right (use directly on db not thru client).

The next thing the setting on your client is important, via which you run the load etc. Check on your client settings in the registry:::>>> the local machine, nls parameters.

What version of Oracle do you use.?

Good luck,
nirasha