When I import data from the text file I exported out of Access it works
correctly except that MySql seems to append and/or prepend some sort of
mystery character to the fields it imports. So, I can get the data into the
database, but I can't get it out (since the SQL statement can't match the
mystery character). I'm using the graphical interface to import data since
it fails at the command line even though my version of MySql is a later one
than the required 3.22.15. The GUI shows the mystery character as a bold
pipe "|". The command line seems to show a problem with the size of the
field. The select * from table statements look like this on the command
line:
+----------+
| Col 1 |
+----------+
| data |
|ta |
|dat|
+----------+
instead of this:
+----------+
| Col 1 |
+----------+
| data |
| data |
| data |
+----------+
My guess is that there is a problem with the end of line character being
exported to the text file from Access. I chose "\n" as the end of line
character to separate records, but maybe it is something else.
Any ideas?
Thanks,
Brad
---------------------------------------------------------------------
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
