Hello.
Are you have MySQL installed on Windows? Windows has a different
symbol for a line end. In what way have you perform a dump? Check
with mysql command line client and SELECT query if you field contains
\r at the end. HEX function might be helpful in this case.
[EMAIL PROTECTED] wrote
To: Lakshmi NarasimhaRao (WT01 - Voice & Next Generation Networks)
Cc: mysql@lists.mysql.com
Subject: RE: Reg insertion of data
That's not dumping. That is loading. Dumping is when you put the data
INTO a file.
Does your source data contain the \r\n pair or not?
You seem to be
i NarasimhaRao (WT01 - Voice & Next Generation Networks)
> Cc: mysql@lists.mysql.com
> Subject: RE: Reg insertion of data
>
>
>
> You also forgot to mention how you are dumping
>
>
> Do you see the trailing \r if you run a normal query on the field? Use
>
teh
end of line.
Thanks,
Narasimha
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005 10:23 PM
To: Lakshmi NarasimhaRao (WT01 - Voice & Next Generation Networks)
Cc: mysql@lists.mysql.com
Subject: RE: Reg insertion of data
You also fo
You also forgot to mention how you are dumping
Do you see the trailing \r if you run a normal query on the field? Use the
HEX() function and look for the value 0D anywhere in the output.
Are you 100% certain that the \r is not part of your original data? If
you look at your source data wi
Sorry, I forgot to mention theat I am inserting into mysql using load
data infile.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005 9:04 PM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Reg insertion of data
Hi,
We