Hey, I'm trying to insert data into a table with a TEXT field but the data I am inserting into the table has a ', present in the data and it gives me an error, the text is as follows:
Of all the motherboard manufacturers in the world, there are only about half-a-dozen who consistently make reliable and efficient boards. Microstar, a company that has been on the motherboard scene for quite a while, is one of those. With their headquarters located in Taiwan, MSI has been able to deliver the excellent motherboards year after year. Microstar's latest outing, the 440BX based MS-6153. Is it possible to use a different type of column so these characters are allowed? it is a for a review so I need it be all grammatically correct with the apostrophes. How do I get around this error? sql Thanks! -------------------------------------------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php