single quote string

[vidhu]

How to insert single quoted string in text field of a database
eg:factors to Alzheimer's disease (AD)

Thanks
Vidhu

[womalley]

escape the single quote

What type of database are you using? Show some of the code that you are using for the insert...

Will

[PiyuNewe]

Yes, it really depends on which database you are using.

But u have to use Escape sequence for insertion such data in colunm.

e.g. to insert data like

D'Souza
i have to type it like
D''Souza.

Its somewhat painful to go though all the data and replace it with double single quotes.

But we have to do !!! no Excuse !!!