Hi,
MySQL not encode characters.In your .txt file are NON-PRINTABLE characters
which mark the end of line.If you have a HEX editor, you can see in the .txt
file at the end of every line '0Dh' and '0Ah'.This mean ENTER('\r) and NEW
LINE(\n').If you have a C/C++ manual you can find the list of escape
sequence.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : gg@stripped
gelugogancea@stripped
----- Original Message -----
From: Alex Pilson <alex@stripped>
To: Gelu <ggelu@stripped>
Cc: <mysql@stripped>
Sent: Thursday, April 25, 2002 12:35 AM
Subject: Re: character
> At 12:23 AM +0300 4/25/02, Gelu wrote:
> >Hi,
> >....because you must use the optional command for fields or lines :
> >Eg.
> >load data infile 'yourfile' into table your_table fields terminated by
> >'\your_delimiter_char_for_fields' lines terminated by '\r\n';
>
> I do. So how does that have anything to do with the trademark
> character getting encoded correctly into a MySQL field?
> --
> <------------------------------------------------->
> Alex Pilson
> FlagShip Interactive, Inc.
> alex@stripped
> 404.728.4417
> 404.642.8225 CELL
>
> // Web Design
> // Lasso Application Development
> // Filemaker Pro / SQL Development
> // Sonic Solutions Creator Authoring
> // Apple DVD Studio Pro Authoring
> // Macromedia Director/Flash Authoring
> <------------------------------------------------->
>
> ---------------------------------------------------------------------
> 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 <mysql-thread107042@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
