match NLS_LANGUAGE settings in existing database

From: BenGounar <Achim.Gounar_at_Orbis.de>
Date: Thu, 26 Aug 1999 08:58:12 GMT
Message-ID: <37c4fca9.6422034@news.salink.net>

Hello!

having a database on Oracle 8.0.x "filled" with data in a german environment (i.e. Strings do contain german special chars) and a server NLS_LANGUAGE already set to 'AMERICAN', how should the settings on server and clients be in order to have correct behaviour on sorting (and performance with FIRST_ROWS):

set client to AMERICAN
set both to GERMAN

How do existing tables/data get affected? Do I need to rebuild indices?

Thanks a lot!

Achim Gounar Received on Thu Aug 26 1999 - 03:58:12 CDT