Re: BDP eating trailing spaces

Article View: borland.public.delphi.database.bdp

Article #3

Back to borland.public.delphi.database.bdp Previous Next

From: Wayne Niddery [TeamB]
Date: Tue, 19 Dec 2006 14:59

14 lines
1648 bytes

news.borland.com wrote:
> Ive found a problem where my app is getting VARCHAR2 fields with their
> trailing space trimmed. A packet trace shows that the data is getting
> to my client box properly, so the trim happens somewhere in BDP code.
>
> How can I get the exact text, I dont want it trimmed.

Then use CHAR fields, not VARCHAR. The definition of VARCHAR is that data 
*should* be returned with any trailing blanks trimmed.

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"At the apex of every great tragedy of mankind there stands the figure
of an incorruptible altruist." - Ayn Rand

Technical Details

Message-ID: <4587fdf9$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news3.google.com!news.glorb.com!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <4586daf5$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>
Subject: Re: BDP eating trailing spaces
Date: Tue, 19 Dec 2006 09:59:04 -0500
Lines: 16
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: <4587fdf9$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1166540281 69.17.150.141 (19 Dec 2006 06:58:01 -0800)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news3.google.com!news.glorb.com!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message