Spaces right-padded in strings?

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Roger Samaan Fri, 10 Nov 2000 00:00

#829

Author: Roger Samaan
Date: Fri, 10 Nov 2000 00:00

10 lines
832 bytes

Hello,

I am converting a 2 tier app with SQL7, BCB5 SP1, to 3 tier with midas.
My first stumbling block is that all my char fields get right padded with
spaces all of a sudden. The ANSI PADDING setting in the server configuration
is set to OFF.

Any Ideas

Roger S

Re: Spaces right-padded in strings?

#740

Author: Jeff Overcash (TeamB)
Date: Tue, 14 Nov 2000 00:00

21 lines
1289 bytes

If your underlying data type is a char and not a VarChar that is exactly what is
supposed to happen.  Char data type is right padded Varchar is not.

Roger Samaan wrote:
> 
> Hello,
> 
> I am converting a 2 tier app with SQL7, BCB5 SP1, to 3 tier with midas.
> My first stumbling block is that all my char fields get right padded with
> spaces all of a sudden. The ANSI PADDING setting in the server configuration
> is set to OFF.
> 
> Any Ideas
> 
> Roger S

-- 
Jeff Overcash (TeamB)   | Talk about failure
(Please do not email    | To fall is not to fail
 me directly unless     | Failure isn't about falling down
 asked.  Thank You)     | Failure is staying down (Marillion)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads