Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgend: Replace "special" Characters in Database ...

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

From: Guido Konsolke <dueto.spam_at_nomail.com>
Date: Mon, 1 Mar 2004 10:45:52 +0100
Message-ID: <1078132890.180263@news.thyssen.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US