Why the single quotation (') mark is not accepted if given in SQL Quries

Question

0.00/5 (No votes)

See more:

Hi All,

I would like to understand more on why the single quotation (') should be handled by replacing with two ' instead of one '. The work around will be working where we replace the single quotation with 2 single quotes.If all other special characters are working fine why only single quote will throw exceptions if not handled properly.

Thanks in Advance !!
Hari

Posted 12-Oct-15 21:49pm

machcha

Add a Solution

3 solutions

Solution 2

Hi,

Programming languages have some predefined rules, specifications and reserve keywords/words/characters. Single quotes (') is a part of SQL query syntax. It starts and terminates the strings in SQL.

Check Dealing with Single Quote[^]

Hope this will help you.

Cheers

Posted 12-Oct-15 22:05pm

Magic Wonder

Solution 3

Single quote represent the start of the varchar values in sql and you can only pass ' within varchar datatype only. thats why when you are going to store varchar value like 'Pankaj's Profile' you have to pass it like 'Pankaj''s Profile'

Posted 12-Oct-15 22:07pm

PANKAJMAURYA

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Accepted Answer · 2015-10-12T22:04:00

Solution 1

In SQL single quote (') used to identify string literals...So as in any other language, you have to escape single quote if you want to use it inside the string literal...In C-like languages the escaping done by slash (\) like \', in SQL it is done by an additional single quote, like ''...

Posted 12-Oct-15 22:04pm

Kornfeld Eliyahu Peter