G'day All
>"kimtest","Kim","","","this is kim�s test stories� to see how we c�n
>accommodate single �quotes� There are a �couple� of �double� quotes here
>to. And �here are some �single� quotes that�re enclosed in
>doubles�","2002-4-4","",""
����
I seem to have found the problem to my own question and it didn't involve
the SQL statement I was using. It seems that mysql was not recognising the
RTF curly quotes (or their text only derivative - (� � � �) as quotes (' or
").
I opened the text document in a text editor and 'stupified' the quotes and
the file now imports perfectly. Would this be considered a bug or something
worth mentioning to the developers?
cheers
kim
---------------------------------------------------------------------
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
