List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 28 2002 6:32pm
Subject:Re: URL encoding
View as plain text  
At 1:50 -0800 1/28/02, Andrei B. wrote:
>Is there a function for URL encoding a value ?
>Here's what I mean :
>select x from y
>returns 'word1 word2 %word3'
>If I were to put this into a URL, some browsers will not handle the URL
>correctly, especially at the space character, also the same happens
>with some proxy servers (like squid at least 2.3)
>I would like to do the following :
>select URL(x) from y
>and see the result : 'word1%20word2%20%27word3'
>which I can safely put into a link and will be handled correctly by all
>browsers and proxies.
>I would like it to be a SQL server function because I use a very
>CGI script for which the queries are completely controled by form
>parameters. I cannot URL encode all returned values, also I can't
>select a certain field and encde it without losing much of the generic
>characteristic of the script.

I'm not sure that makes sense.  You have to be able to tell at *some*
level which values are to be url-encoded.  Given that, it may not matter
much whether it's done by the MySQL server, or by your script.

However, given that your scripting language probably already has a function
to do that, and MySQL does not, the quicker solution is the use your scripting

But you didn't indicate what language you're using, so we can't answer the
question for you.

>ing. Andrei Boros
>Centrul pt. Tehnologia Informatiei
>Societatea Romana de Radiodifuziune

URL encodingAndrei B.28 Jan
  • Re: URL encodingPaul DuBois28 Jan