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

[Thomas Henz]

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]

Well I found URLEncode. This should do!

But:

when I try to do:

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

Tom

 

[Pappas Mike]

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...