469,275 Members | 1,835 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

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

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,


Jul 19 '05 #1
2 1337
Well I found URLEncode. This should do!


when I try to do:

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


Jul 19 '05 #2
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...
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by John M | last post: by
2 posts views Thread by Ajai Kumar .R | last post: by
9 posts views Thread by Mark | last post: by
64 posts views Thread by Bayazee | last post: by
13 posts views Thread by jeff | last post: by
11 posts views Thread by dusk | last post: by
17 posts views Thread by may bailey | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.