Re: Urgend: Replace "special" Characters in Database ...

"Michael Poremski" <280264_at_web.de> schrieb ...
> Hi experts,
>
> after a wrong working WEB Application, I have some wrong records
in a
> Oracle 8.1.7 Database. The German "Umlaut" Characters like "ä" are
> replaced to "&auml" in the Database. (VARCHAR Field)
>
> My Idea was, to replace the wrong Chacacters: "&auml" to "ä" ....
>
> I want use the "REPLACE(DBString, "ä","&auml") Command. But I
don't
> find any way to use it on SQL Worksheet or "DBA Studio". I
suppose,
> that the Character Sequence "&auml" Converted to "ä" into the User
> Interface. ... It won't work ...
>
> By example (to check the REPLACE Command):
>
> SELECT REPLACE(problem.title,"&auml","ä") FROM problem;
>
> Is there a special Escape Character available to replace such
special
> characters?
>
> Many thanks!!
>
> Michael Poremski

Hallo Michael,

I never worked with the tools you mentioned. In sql*plus you can define
a 'escape character' this way: "SET ESCAPE \;" (without double quotes).
Then your example statement has to be altered: SELECT REPLACE(problem.title,'\&auml','ä') FROM problem;

Please note that I changed the double quotes to single quotes. Your task is to find out how and where you can define such characters
in the tools you use.

hth,
Guido Received on Mon Mar 01 2004 - 03:45:52 CST