RE: replace chr(10) in field
I thought this, but when I display the information in a Memo box in my C++ builder application I get little square boxes (binary type chars). And all the information is displayed on the same line.
Any ideas why ?
> Date: Wed, 14 May 2008 13:08:04 -0500> From: gclark@xxxxxxxxxxxxxxxxxxx> To: neildtompkins@xxxxxxxxxxx> CC: mysql@xxxxxxxxxxxxxxx> Subject: Re: replace chr(10) in field> > Neil Tompkins wrote:> > Hi,> > > > I've got some data in our fields which contain a carriage return 'chr(10)', as saved using a ASP page. I'm now trying to extract the information from a different system, however the saved chr(10) are showing as binary values.> > > > What would be the best way for my to replace chr(10) to a \n ? I tried using the mysql REPLACE() function, but it did not appear to work.> > > > Thanks,> > Neil> > _________________________________________________________________> > > > All new Live Search at Live.com> > > > http://clk.atdmt.com/UKM/go/msnnkmgl0010000006ukm/direct/01/> > Chr(10) is a \n.> Chr(13) is a \r.> -- > Gerald L. Clark> Sr. V.P. Development> Supplier Systems Corporation> Unix since 1982> Linux since 1992
_________________________________________________________________
All new Live Search at Live.com
http://clk.atdmt.com/UKM/go/msnnkmgl0010000006ukm/direct/01/