Hi,
We are inserting the text data into mysql. But, when we see the
dump of that table, we are seeing '\r' at the end of the value of that
text. Actually we are not inserting the data with '\r'. Can any one of
you help me in removing that '\r', imean I donot want to see that '\r'
even in
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
]
Sent: Tuesday, October 04, 2005 9:04 PM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Reg insertion of data
Hi,
We are inserting the text data into mysql. But, when we see the
dump of that table, we are seeing '\r' at the end of the value of that
text. Actually we
.
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 forgot to mention how
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
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 using the default
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]