How to read Punctuation Symbol value from database?

There is no problem in storing single quotes in database field.

But when retrieving it is throwing an error in the criteria expression. The reason for the failure is the single quote which is part of the string in your WHERE criteria column (when customername is "spencer's plaza"). The SQL engine will try to interpret your SQL statement and will consider the single quote inside the string as the end of that string. The remaining part of the SQL statement (in your case it is "s plaza" cannot be interpreted correctly, thus you are getting an error.

The solution is by replacing all single quotes in your string with two single quotes. When we have two single quotes together, they are interpreted by SQL as one single quote.

customername=spencer's plaza

i stored the value in customername field like above format...


select Customername from tablename customerName='customername'

You can escape the single quote by repeating it. So replace ONE single quote with TWO single quotes in the WHERE Clause

e.g. SELECT CustomerName FROM TableName WHERE CustomerName = 'spencer''s plaza'

If you are using ADO.NET Command Object with Parameterized Query, it automatically solves the problem (you don't have to escape the single quotes)