Re: I have Problems with German spezial characters

Hi Mike,

Usually this is pointing to a far more serious problem: your database has been created in the wrong characterset. This should be WE8ISO8859P1 in Western Europe and chances are it is US7ASCII in your case. There are two methods to change this, one official and one unofficial (and unsupported). This first one is, guess what, recreate the database, using the correct characterset in the create database statement. The other one is fool around with the internal prop$ table, but don't ask me how to do this. It has been explained in this newsgroup though, you should be able to find it in archives. I don't advocate this method though.
Too quickly verify which characterset your database is really in, make a direct export. This will always execute in the native characterset of the database, regardless of your NLS_LANG settings.

Hth,

Sybrand Bakker, Oracle DBA

Mike wrote:

> Hi
>
> I have updated from 7.0.16 to 7.3.4 and also the SQL Net version on the
> Clients. The problem i have is that the German chars are wrong ( Ü (UE) is
> for example \ and ö (oe) is V and so on ). I have tryed to change the
> NLS_LANG in the registry but that have no effekt. The problems come from
> the old client SQL NET Version, because if a update is made like insert
> ..... Ü ......... ( operation on the client) so is in the database a \
> (select * from .... on the server with svrmgr)
> I have allso export the database and import it but with no effekt.
> And i have no idea what can i do aginst this problem.
> A little light i the dark is with the replace command but i have never used
> before and my trys are not really successfull
>
> If there any specialist that have the knowleg about the insert into .....
> select .. replace.... from ..... command
>
> Thanks for help
>
> MIKE

Received on Wed Dec 30 1998 - 05:54:05 CST