🚀 go-pugleaf

"Bob Swart" <b.swart@chello.nl> wrote in message 
news:4586F404.1060904@chello.nl...
> Hi "news",
>
>> 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.
>
> I thought that VARCHAR fields were always truncated?
>
> Groetjes,
>           Bob Swart


I don't believe so. Anyways, I do have data in my database which has 
trailing spaces. Those spaces aren't making it to my client code. This is a 
problem because I am doing the WHERE clause style of concurrency checking... 
so my WHERE clause never matches in these cases since I don't have the same 
data the server has.

I should point out that I am using Oracle (v8 and v9).

I just created a simple test bed application with two text boxes.
One text box is bound to a dataset generated and filled by BDP.
The other text box is bound to a dataset generated and filled by MS Oracle 
provider.
Both are querying the exact same table.field.
MS Oracle provider is getting showing the data correctly with all trailing 
spaces intact.
BDP is not.

Is this a bug? any ideas?

thanks :)