Article View: borland.public.delphi.database.bdp
Article #9Re: BDP eating trailing spaces
From: Wayne Niddery [TeamB]
Date: Thu, 21 Dec 2006 04:22
Date: Thu, 21 Dec 2006 04:22
19 lines
2221 bytes
2221 bytes
john wrote: > > The trailing blanks aren't really 'important' to preserve. Its just a > problem of existing data and also I have to operate side by side with > another application that I can't really modify or control. Why are the > spaces in the data? I dont know, blame the users. :) Ok, then in my opinion (which cannot of course supercede your own if it differs <g>) is that you don't have to do anything, it'll be ok if your app strips them and puts them back. The only possible issue I see is if there are full string comparisons being made in the other app rather than sql "like xxx%", but then if users are putting essentially random trailing blanks in anyway, then this is already either a problem or not and if it is, your app won't make things worse and will gradually make them better. -- Wayne Niddery - Winwright, Inc (www.winwright.ca) Working for yourself is great because you get to work half days, and you can choose any twelve hours you want.
Technical Details
Message-ID:
<458a0bc8$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wns14feed!worldnet.att.net!208.48.142.85!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<4586daf5$1@newsgroups.borland.com> <4587fdf9$1@newsgroups.borland.com> <45881d02@newsgroups.borland.com> <4589592f@newsgroups.borland.com> <45897066$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 1effeb,55aa26900fbb2200 X-Google-Attributes: gid1effeb,public X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.delphi.database.bdp References: <4586daf5$1@newsgroups.borland.com> <4587fdf9$1@newsgroups.borland.com> <45881d02@newsgroups.borland.com> <4589592f@newsgroups.borland.com> <45897066$1@newsgroups.borland.com> Subject: Re: BDP eating trailing spaces Date: Wed, 20 Dec 2006 23:22:33 -0500 Lines: 21 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 69.17.150.141 Message-ID: <458a0bc8$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1166674888 69.17.150.141 (20 Dec 2006 20:21:28 -0800) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wns14feed!worldnet.att.net!208.48.142.85!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail