SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-16-2008, 01:40 PM
| ||||
| ||||
 replace chr(10) in field 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 froma 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/msnnkmgl...ukm/direct/01/      |
|
05-16-2008, 01:40 PM
| |||
| |||
| 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 allthe information is displayed on the same line. Any ideas why ? > Date: Wed, 14 May 2008 13:08:04 -0500> From: gclark@suppliersystems.com> To: neildtompkins@hotmail.com> CC: mysql@lists.mysql.com> 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/msnnkmgl...ukm/direct/01/ |
|
05-16-2008, 01:40 PM
| ||||
| ||||
| RE: replace chr(10) in field I've overcome the problem by using a RichText memo box. Thanks for your help in any case. Neil > From: neildtompkins@hotmail.com> To: gclark@suppliersystems.com> CC: mysql@lists.mysql.com> Subject: RE: replace chr(10) in field> Date: Wed, 14 May2008 19:18:07 +0000> > 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@suppliersystems.com> To: neildtompkins@hotmail.com> CC: mysql@lists.mysql..com> 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/msnnkmgl...ukm/direct/01/ __________________________________________________ _______________ All new Live Search at Live.com http://clk.atdmt.com/UKM/go/msnnkmgl...ukm/direct/01/ |
 |
« comparison operations in IN subquery
|
Res: Table Locking (Was: Best CPU config for a busy DB server) »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:49 AM.
