How to get strings containig the char ' into mysql?

[Garfield]

Hi,

I'm having roblems with saving texts containing the char ' (like in O'Brien) into mysql. Since PHP seems to recognize this character as string delimiter, it doesn't work.

How can I get around this? Do I have to escape all ' chars like this: \'? Or is there a better way of getting them saved into mysql?

Thanks in advance!

[kniceguy2know]

Check out the addslashes() function in php. I think it'll serve your purpose quite well. Tell me if it works out.

[willybfriendly]

addslashes() or mysql_escape()

WBF

[Garfield]

I used the mysql_escape_string function and now everything works properly.

Thanks

[Sarvesh Nagpal]

Any suggestions if we have to deal with same problem in language PERL?

[coopster]

If you are using the DBI Module you can quote [cpan.uwinnipeg.ca] 'em.

[Sarvesh Nagpal]

Thanks coopster! It works great.