Link to home
Start Free TrialLog in
Avatar of Waponi
Waponi

asked on

MS smart quote substitution

Hello,
I have a spring app which accepts sql statements thru a gui / post request.
The statements can have MS smart quotes like
Select ’02-may-2011’,’dd-mon-yyyy’ from dual;

I was anticipating substituting the smart quotes on the server side with normal quotes,
but  debugging the statement at the request reveals that a substitution has already been done with the '?box' = 63 char for any smart quote.

My question is who or what (spring, http request etc) automatically changes the smart quotes to boxes in between the post and the request ?

Also is there a way of preventing this so I can see them on the server side and do my own sub ?
thanks
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

They will be urlencoded by whatever does the post
Avatar of Waponi
Waponi

ASKER

So <%@page contentType="text/html" pageEncoding="UTF-8"%> will encode all post request parameters ?
ASKER CERTIFIED SOLUTION
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Waponi

ASKER

Thanks for the clarification