Dear Sir, my name is Martin Weber and I study IT at the University of Dortmund. For my diploma I need a non comercial database and I decide to use MySQL. Now I stumbled into a question, and I hope for your help: I want to insert data into a table with the "LOAD DATA INFILE" function. The data has imbedded signle quotation marks in a text string, e.g. 12'34. When the data is loaded, and I do a select over the table, I get the text string displayed as 12\'34 instead of the expected 12'34. The question is: What have I to do to get the loaded data displayed correctly? Thanks in advance for any help. Kind regards, Martin Weber --------------------------------------------------------------------- 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