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

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 Received on Sun Feb 29 2004 - 12:37:03 CST