shong

shong

Running the string through a URL decoder would reveal the token however for references the following can be used to convert the string:

• $ (Dollar Sign) becomes %24
• & (Ampersand) becomes %26
• + (Plus) becomes %2B
• , (Comma) becomes %2C
• : (Colon) becomes %3A
• ; (Semi-Colon) becomes %3B
• = (Equals) becomes %3D
• ? (Question Mark) becomes %3F
• @ (Commercial A / At) becomes %40
• / (Forward Slash) becomes %2F

You can see the full map of character encoding at http://www.degraeve.com/reference/urlencoding.php 

I hope this helps,

Worked perfect for me. Added a where so I only get accepted solutions back.

SELECT solution_data,is_solution FROM messages WHERE is_solution = true

Thanks!