ASCII table is the same for ALL OS. In my understanding to be a "new line character" is to have a different representation.. So ...always: the LineFeed is 0Ah and CarriageReturn is 0Dh Windows use 0A,0D and some *nix editors use only 0A to make new line. This is means only the "rule" for "breaking" lines in a sequential file is different. The characters which are used in this "rule" are the same. 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:33 PM Subject: RE: Problem importing data from Access > This is incorrect. > > !google "new line character" linux windows > > -----Original Message----- > From: Gelu Gogancea [mailto:ggelu@;arctic.ro] > Sent: Wednesday, November 06, 2002 11:33 AM > To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor); > [EMAIL PROTECTED] > Subject: Re: Problem importing data from Access > > > 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