converting into UTF8

[Erikxxx]

Hi all

I am running a server (windows 2000 Oracle 8.1.7) but is now testing on Oracle 9.2 here in the UK where I have installed UTF8 as characterset (also as national charset). The registry settings are ENGLISH_UNITED KINGDOM.WE8MSWIN1252 which correspond to the servers locale. However the database itself using American America (but UTF8) as NLS parameters.

I'm having major problems with data input using french and swedish through our webapplication (running Tomcat 5.5). The foreign characters get converted into other symbols when I look in the database.

I've been thinking that maybe the nls_territory and nls_language database settings must correspond to the settings in the windows registry.

I've actually been trying to alter the session but without result. I tried to do the following.

alter session set nls_territory = 'UNITED KINGDOM';
execute dbms_session.set_nls('NLS_TERRITORY','"UNITED KINGDOM"');

Secondly, I'm wondering if the characterset in the registry should be set to UTF8

Third: I'm still not sure yet if Tomcat needs to be configured for UTF8 (next on my list to check)


Any ideas

Thanks
Erik