how to hide %20, %x or + when getting from DB

Discussion in 'ASP General' started by Thomas Henz, Aug 22, 2003.

  1. Thomas Henz

    Thomas Henz Guest

    Hi there!

    I migrated a mysql DB into a MSSQL DB. In this DB all chars like "blank"
    or @ are encoded in...whats it called in english? :)
    you know, when a blank is "+" or @ is "%40"... :)

    How do I resolve those "%20"s back into a readable character or a blank
    with asp?
    Plus: How do I convert blanks into + again to write them back into the DB.

    Thanks a lot,

    tom
    Thomas Henz, Aug 22, 2003
    #1
    1. Advertising

  2. Thomas Henz

    Thomas Henz Guest

    Well I found URLEncode. This should do!

    But:

    when I try to do:

    response.write(server.urlencode(rs("datafield"))) it wont do :(

    Tom
    Thomas Henz, Aug 22, 2003
    #2
    1. Advertising

  3. Thomas Henz

    Pappas Mike Guest

    Try to re-import your data from mysql to mssql. The best way is to import
    your data from mysql to mssql using Ms Data Transormation Services and the
    correct odbc driver for mysql of course...
    Pappas Mike, Aug 22, 2003
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jerad Rose

    Dynamically Show/Hide Groups of TR's

    Jerad Rose, Jun 24, 2003, in forum: ASP .Net
    Replies:
    12
    Views:
    11,574
    intrader
    Jul 10, 2005
  2. Jurij P

    hide password on client side

    Jurij P, Jul 7, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    388
    Wim Hollebrandse
    Jul 7, 2003
  3. Replies:
    3
    Views:
    380
  4. Hunt Jon
    Replies:
    2
    Views:
    97
    Phlip
    Dec 18, 2008
  5. George
    Replies:
    4
    Views:
    586
    Roedy Green
    Jun 28, 2012
Loading...

Share This Page