Hi,
You must use a HEX editor to see this characters which are not printable.I
use DOS NAVIGATOR...it's free and you can download it from the INTERNET.
You must view the file in HEX and find the characters "0A,0D"
on the end of line.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]>
To: "'Black, Kelly W [PCS]'" <[EMAIL PROTECTED]>; "'Gelu
Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 9:41 PM
Subject: RE: Problem importing data from Access
> The text file seems to be fine as far as I can tell. The columns are all
in
> the correct order.
>
> It sounds like I need to look out for the "line feed" character, as well
as
> the carriage return since I'm working on Windows. Anybody know how the
line
> feed character is represented?
>
>
> -----Original Message-----
> From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
> Sent: Wednesday, November 06, 2002 12:34 PM
> To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor);
> [EMAIL PROTECTED]
> 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
