Re: SQL Question

You seem to have a problem with the way characters are displayed, Hex 26 is the ascii code for &, so I'd say your database is returning the correct characters.

I'm afraid I don't know where the problem is but I doubt you can fix it with SQL, your TRANSLATE satatement would not work in any case because TRANSLATE only does one to one character translation.

Robert

On Fri, 25 Feb 2000 17:13:11 -0800, Misha <mshor_at_brodia.com> wrote:

>Hello, everybody!
>
>Here's SQL problem I cannot solve.
>
>Our database contains some records with special characters such as "A&B
>Software".
>When I execute query Oracle returns the results in a form of "A%26B
>Software". & symbol is being replaced with the "%26" string ( ' symbol
>is replaced with %27 string and so on for the rest of special
>characters).
>What should I do in order to get results as "A&B Software"?
>
>Thanks in advance
>
>Misha
>http://www.brodia.com
>
>P.S. When I retrieve the record such as "first last" result is in the
>form "first+last". I can fix it by simply using TRANSLATE (column_name,
>'1+' , '1 ' ). This will replace + sign with the space. But when I use
>TRANSLATE (column_name, '1"%26"' , '1& ' ) it doesn't work.
>
Received on Mon Feb 28 2000 - 00:00:00 CST