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
