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 : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: Alex Pilson <[EMAIL PROTECTED]>
To: Gelu <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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.
> [EMAIL PROTECTED]
> 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 <[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
