Hi, I have a third party application that is using SQL database. When we enter a name with quotes (Ex: O'neal) through application it is being stored in the database with a square box instead of the quote (Run 'select char(2)' from your QA and you'll know what square box I'm talking about). But, when I list the same name through application it is displaying properly with quotes. It looks like the application converting the quote to this special character while storing and converting it back while retriving it. But, when I modify this name to replace the special character with quote (through QA), the application can no longer find this name, i.e. when I try to search through application for this name (O'neal) it returns zero results. What could be wrong ? The application vendor is blaming on the character set being used for the database. How can it be character set, When I am able to store the right character through QA ? Please suggest.