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

Reply via email to