MAC %20 Problem

This is a web based application.  The application is for a company who receives uploaded documents from clients, via http from Netscape or Internet Explorer.  The uploaded document is uploaded and the document name is placed in the Database.  When the client Operating System is a Macintosh the following occurs:  If there are spaces in the filename the spaces are then changed into %20 so:
FileName:  Hello There
Changed to:  Hello%20There
i need to know what the problem is and how to fix it.
Achilles25Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ipierceCommented:
well that's certainly something you see a lot on the web.  the %20 refers to ASCII character number 20, which is a space.   Other nonstandard characters (i.e. not seen in URLs) like ! get a %22 or something like that.  Not that I know the fix, but maybe this will help.

also, please clarify a bit what is happening:  the mac client is uploading a file thru netscape or IE, on the mac it's called "hello there" but when it gets to the other end you see "hello%20there" as the file that just got uploaded to the server?  Is that accutare?
0
squintCommented:
The solution is to run the file name through a "URL decode/escape" function.  You just need to account for this on the server application.  On Windows, all spaces in file names are internally translated to the "+" character, when the file is selected.  On the Mac, the spaces are translated to "%20".  All character are translated *again* when the form is submitted; the "+" character does not get escaped, but "%20" becomes "%2520" (25 is the hex code for the '%' character)!  This probrably should be classified as a bug.

An alternative is to write a JavaScript routine to obtain and encode the file name in the same manner across OS's.
0
TheHubCommented:
the problem is minor. tell the user...thats just the way it is.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

TheHubCommented:
the problem occurs most often when the file is uploaded to an http server and not the correct ftp server. people do this if there is no ftp server available.
0
chrisxxCommented:
The fix is simple: just use an _ (underscore) in place of a space
0
chrisxxCommented:
The fix is simple: just use an _ (underscore) in place of a space
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apple Hardware

From novice to tech pro — start learning today.