Try using QUOTE function. Asif Iqbal wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was working fine. However recently I had few logs that had apotrophe and I failed to insert those lines into my database. It said syntax error. Is there any patch anything I can put and recompile mysql so it won't fail while inserting log lines that has apotrophe (') in it ?
Thanks a lot
- -- Asif Iqbal
PGP Key: E62693C5
There's no place like 127.0.0.1
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (SunOS)
iD8DBQE//LS0UAgaF+Ymk8URAs3xAJ0W8c3tSgWd6xE45qLB25KTSJRv3wCffEb3 eDhzNcJuik1HH3J8CQYj77A= =eUX1 -----END PGP SIGNATURE-----
--
Aftab Jahan Subedar CEO/Software Engineer Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http://www.DhakaStockExchangeGame.com/ - [EMAIL PROTECTED] http://www.CEOBangladesh.com/ - [EMAIL PROTECTED] http://www.geocities.com/jahan.geo/ - [EMAIL PROTECTED] sms://+447765341890 tel://+88027519050 EMail://[EMAIL PROTECTED] - Directly to my notebook
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]