On Tue, 15 Feb 2005 17:34:43 -0800, Jacques Kilchoer <Jacques.Kilchoer@xxxxxxxxx> wrote: > > I thought you couldn't set NLS_CHARACTERSET on the client. Do you mean > NLS_LANG? Yes, I meant NLS_LANG. > > If you want to change NLS_LANG, you could create a different batch file for > each application, e.g. > > set nls_lang=ENGLISH_UNITED KINGDOM.WE8ISO8859P1 > %oracle_home%\bin\sqlplus > > and create a shortcut to the batch file in the Start Menu or on the desktop. > > But this seems too simple so I must be missing something. Simple yes, but I would greatly prefer not adding an active element ( a batch file) to the apps. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l