Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.glorb.com!news2.telebyte.nl!fu-berlin.de!uni-berlin.de!p50925247.dip0.t-ipconnect.DE!not-for-mail From: Marc Blum Newsgroups: comp.databases.oracle.server Subject: Re: Converting from WE8MSWIN1252 to WE8ISO8859P1 Date: Sat, 17 Apr 2004 16:31:14 +0200 Lines: 26 Message-ID: References: <40811792$0$26193$cc9e4d1f@news-text.dial.pipex.com> Reply-To: blum@marcblum.de NNTP-Posting-Host: p50925247.dip0.t-ipconnect.de (80.146.82.71) Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.uni-berlin.de 1082212118 5129497 I 80.146.82.71 ([158905]) X-Newsreader: Forte Agent 1.93/32.576 English (American) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:259695 On Sat, 17 Apr 2004 15:30:30 +0200, Sybrand Bakker wrote: >On Sat, 17 Apr 2004 12:40:04 +0100, "Adam McDonagh" > wrote: > >> Or am I going to have to >>reinstall Oracle? > >Of course not. >Export the affected database, create a new database with the correct >characterset, import the database. > >Note: the 'hack' Marc Blum published will most likely not be supported >by OTS, so I strongly advise against doing that. Dear Sybrand, anyone with access to metalink will be able to find several documents describing this command. So there's nothing wrong with repeating it here. -- Marc Blum mailto:blumNOSPAM@marcblum.de http://www.marcblum.de