Learn how to a build a cloud-first strategyRegister Now


MS smart quote substitution

Posted on 2011-05-04
Medium Priority
Last Modified: 2012-05-11
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 ?
Question by:Waponi
  • 2
  • 2
LVL 86

Expert Comment

ID: 35693076
They will be urlencoded by whatever does the post

Author Comment

ID: 35693201
So <%@page contentType="text/html" pageEncoding="UTF-8"%> will encode all post request parameters ?
LVL 86

Accepted Solution

CEHJ earned 252 total points
ID: 35693567
It's the browser (usually) that will do it
LVL 92

Assisted Solution

objects earned 248 total points
ID: 35702932
you'll need to configure you're server (for example with a charset filter) to set the encoding correctly

Author Closing Comment

ID: 35805143
Thanks for the clarification

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
A solution for Fortify Path Manipulation.
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
Suggested Courses
Course of the Month20 days, 19 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question