At 01:10 PM 3/31/02 -0600, Alex Behrens wrote: >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
What language are you using? What is the insert statement you are using? -Lance --------------------------------------------------------------------- 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
