Inserting an url encoded string

[maslett]

Hi, I have an URL encoded string such as:

line++++1%0D%0A%0D%0Aline+2%0D%0A%0D%0Aline+3

that equates to

line    1

line 2

line 3

What I need to do is write the string to mysql but *also* keep the formatting as I have to display the string on a web page at a later date.

I'm stumped!

(btw - am trying to write this in perl)

Cheers,
Matt

 

[TonyGroves]

You could use 2 fields, one encoded, the other unencoded. Alternatively (and better if you can manage it, because it eliminates redundancy), just store it encoded, and decode it every time you access it.

 

[maslett]

Now why didn't I think of that?

Thanks Tony