EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 5:45 AM
Subject: [SQL] Bad encoding in URL
> Hi
>
> I have some URLs in a database but some of the URL contain %3A and so on..
>
> Is there an easy way of converting '%3A' to ':&#x
Maybe you want to look here:
http://www.brasileiro.net/postgres/cookbook/
mimic oracle's replace function. versions in pltcl
and plpgsql.
If the function you want isn't built in to
posgresql...
Ted
--- HR <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have some URLs in a database but some of the URL
Hi
I have some URLs in a database but some of the URL contain %3A and so on..
Is there an easy way of converting '%3A' to ':' ???
I cannot find any replace(String str, String str) among the string
functions.
ThankYou.
---(end of broadcast)---
T
