RE: NLS_CHARACTERSET client settings
- From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Feb 2005 11:52:08 +1100
Jared,
Do they need to be able to run both apps simultaneously?
If not, could start via batch (Perl?) and have it update registry.
Actually a better sounding way (but haven't tested it) that would allow =
running simultaneously
again start via batch (Perl?) - and have it set a (local to that =
programs environment) environment variable of nls_characterset with the =
right name.
Just ideas that may spark further thoughts.
HTH,
Bruce Reardon
-----Original Message-----
From: Jared Still
Sent: Wednesday, 16 February 2005 11:46 AM
Subject: NLS_CHARACTERSET client settings
2 apps - One of them requires UTF8, the other simply will not work =
properly when NLS_CHARACTERSET is set to UTF8.
One possible solution is to install 2 copies of the Oracle client
so that there are 2 oracle homes. Haven't tried it yet, but it
may not work well, dependent on how the client locates Oracle.
If via PATH, then installing 2 clients is a no go, and this only
really viable for a limited number of clients (admins). Not really
a good solution to push out to the help desk.
The client is 9i, the databases are 9i and 8i.
9i: NLS_CHARACTERSET =3D WE8ISO8859P1
8i: NLS_CHARACTERSET =3D UTF8
Thanks,
Jared Still
NOTICE
This e-mail and any attachments are private and confidential and may =
contain privileged information. If you are not an authorised recipient, =
the copying or distribution of this e-mail and any attachments is =
prohibited and you must not read, print or act in reliance on this =
e-mail or attachments.
This notice should not be removed.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
