Until 22/01/03, the database was 8.1.6. and it got upgraded to 8.1.7.4.1. on 23/01/03.(still on WindowsNT 4.0)

I tried to do an export for the first time since the upgrade and came across the following error:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
EXP-00041: Export done in server's WE8DEC, different from user's
Character set WE8ISO8859P1
EXP-00000: Export terminated unsuccessfully


which I didn't have before. And I am aware that if I take direct=y off the exp parameter, the exp runs fine.

I have looked up in Metalink about this error, and most common solution is to make sure Server and Client (user) have the same character set. Rather unfortunately, I could not find any practical notes - i.e. with actual syntax of how to change the character set and what impact it might have.

I would appreciate if any of you could help me with the syntax to amend this error.

Cheers
Fiona