Hi, Is no difference but in *nix some text editors (like "vi" for example) put only the LineFeed(0Ah) character and not CarriageReturn and LineFeed like in Windows(0Dh,0Ah). Almost sure is something wrong with the .txt file.Few days a go i have a similar situation and it was from the the dump/.txt file.Data in the .txt file must be in the same order with the fields/columns from MySQL table.
Regards, Gelu _____________________________________________________ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] ----- Original Message ----- From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]> To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 9:04 PM Subject: RE: Problem importing data from Access > I have seen this when Windows was involved. > Windows word and note pads have a different new > line character than Un*x type systems. > > Perhaps that's what's foiling the sql query. > > > ~K Black > > -----Original Message----- > From: Gelu Gogancea [mailto:ggelu@;arctic.ro] > Sent: Wednesday, November 06, 2002 10:54 AM > To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED] > Subject: Re: Problem importing data from Access > > > Hi, > Are you sure that .txt file is OK? > > Regards, > > Gelu > _____________________________________________________ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > ----- Original Message ----- > From: "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, November 06, 2002 7:06 PM > Subject: Problem importing data from Access > > > > 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 > > > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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