URL encoding with SQL?

#1

Hi,

I fetch some parameters from a table which I use as GET-Parameter in an URL.
Unfortunately there are sometimes special characters like 'ä', 'Ö', 'ü'
included so I have to url-encode these data during the generation of the
URL.

Has anybody an idea how I can url-encode a string with an SQL command /
function?

Thanks and best regards,
Jens

#2

On 1 Apr., 15:36, Jens Riedel <Jens... (AT) gmx (DOT) de> wrote:

Quote:

Hi,

I fetch some parameters from a table which I use as GET-Parameter in an URL.
Unfortunately there are sometimes special characters like 'ä', 'Ö', 'ü'
included so I have to url-encode these data during the generation of the
URL.

Has anybody an idea how I can url-encode a string with an SQL command /
function?

Thanks and best regards,
Jens

UTL_URL.ESCAPE

hth, Urs Metzger

#3

On 1 Apr., 15:36, Jens Riedel <Jens... (AT) gmx (DOT) de> wrote:

Quote:

Hi,

I fetch some parameters from a table which I use as GET-Parameter in an URL.
Unfortunately there are sometimes special characters like 'ä', 'Ö', 'ü'
included so I have to url-encode these data during the generation of the
URL.

Has anybody an idea how I can url-encode a string with an SQL command /
function?

Thanks and best regards,
Jens

UTL_URL.ESCAPE

hth, Urs Metzger

#4

On 1 Apr., 15:36, Jens Riedel <Jens... (AT) gmx (DOT) de> wrote:

Quote:

Hi,

I fetch some parameters from a table which I use as GET-Parameter in an URL.
Unfortunately there are sometimes special characters like 'ä', 'Ö', 'ü'
included so I have to url-encode these data during the generation of the
URL.

Has anybody an idea how I can url-encode a string with an SQL command /
function?

Thanks and best regards,
Jens

UTL_URL.ESCAPE

hth, Urs Metzger

#5

On 1 Apr., 15:36, Jens Riedel <Jens... (AT) gmx (DOT) de> wrote:

Quote:

Hi,

I fetch some parameters from a table which I use as GET-Parameter in an URL.
Unfortunately there are sometimes special characters like 'ä', 'Ö', 'ü'
included so I have to url-encode these data during the generation of the
URL.

Has anybody an idea how I can url-encode a string with an SQL command /
function?

Thanks and best regards,
Jens

UTL_URL.ESCAPE

hth, Urs Metzger

#6

metzguar schrieb:

Quote:

UTL_URL.ESCAPE

Works great, thank you very much!

Jens

#7

metzguar schrieb:

Quote:

UTL_URL.ESCAPE

Works great, thank you very much!

Jens

#8

metzguar schrieb:

Quote:

UTL_URL.ESCAPE

Works great, thank you very much!

Jens

#9

metzguar schrieb:

Quote:

UTL_URL.ESCAPE

Works great, thank you very much!

Jens

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

URL encoding with SQL?

comp.databases.oracle.misc comp.databases.oracle.misc

URL encoding with SQL? - 04-01-2008 , 08:36 AM

Re: URL encoding with SQL? - 04-01-2008 , 09:27 AM

Re: URL encoding with SQL? - 04-01-2008 , 09:27 AM

Re: URL encoding with SQL? - 04-01-2008 , 09:27 AM

Re: URL encoding with SQL? - 04-01-2008 , 09:27 AM

Re: URL encoding with SQL? - 04-02-2008 , 10:00 AM

Re: URL encoding with SQL? - 04-02-2008 , 10:00 AM

Re: URL encoding with SQL? - 04-02-2008 , 10:00 AM

Re: URL encoding with SQL? - 04-02-2008 , 10:00 AM