how to use different oracle character sets in one application

i'm developing a 32bit Client-Application with Delphi. From this application I need to connect to databases on two different servers. First databse character set ist WE8MSWIN1252, the other server decodes with WE8PC850. Setting the client NLS_LANG parameter to the correct value solves correct sql-query results.

Unfortunately this (the client character-set) seems 开发者_StackOverflow中文版only to be recognized on applications startup (first connect to oracle). I need to change the client-characterset at runtime. Oracle client seems to store the character set an application used to connect!

beside: I#m using udl-files to setup the connections (Microsoft OLE DB - driver)

what can I do?

You could use ALTER SESSION calls to change the settings at the session level after connecting to the database.

I need to change the client-characterset at runtime.

Why ? I would have thought what you want at the client end is a character set that is acceptable to the operating environment and end-user.

Pick out a character set such as UTF-8 and let Oracle handle the conversion between the client character set and the two database character sets.