MS smart quote substitution

Posted on 2011-05-04
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
    LVL 86

    Expert Comment

    They will be urlencoded by whatever does the post

    Author Comment

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

    Accepted Solution

    It's the browser (usually) that will do it
    LVL 92

    Assisted Solution

    you'll need to configure you're server (for example with a charset filter) to set the encoding correctly

    Author Closing Comment

    Thanks for the clarification

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The task A number given should be formatted for easy reading by separating digits into triads. Format must be made inline via JavaScript, i.e., frameworks / functions are not welcome. So let’s take a number like this “12345678.91¿ and format i…
    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
    Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now