Handeling ASCII characters in MySQL

Discussion in 'MySQL' started by ForgottenCreature, Mar 30, 2006.

  1. #1
    I am stumped on this one.

    I am currently trying to read a variable into a query and select the row I am looking for from that. Here is an example.

    http://www.tripsafety.net/work/view/4
    Try clicking "Greenhouse Calamities – Thoughts from a Novice Gardener" (http://www.tripsafety.net/work/arti...amities-–-Thoughts-from-a-Novice-Gardener.htm)

    I need a way to pass that ASCII character (the one that looks like a dash in the title) along through the GET variable so I can check for that article name in my database.

    Anyone know how to do this? I hope this explanation is good enough.
     
    ForgottenCreature, Mar 30, 2006 IP
  2. exam

    exam Peon

    Messages:
    2,434
    Likes Received:
    120
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Encode the title with urlencode() before passing it via GET. On the other side, use urldecode() to get the original string.
     
    exam, Mar 31, 2006 IP