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
