Re: Spaces right-padded in strings?

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

Article #740

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#740

From: 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)

Technical Details

Message-ID: <3A10D67C.FD7D217C@onramp.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3a0c4fc5$1_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,eab177243d8b4cce
X-Google-Attributes: gidfcd2b,public
From: "Jeff Overcash (TeamB)" <overcash@onramp.net>
Subject: Re: Spaces right-padded in strings?
Date: 2000/11/14
Message-ID: <3A10D67C.FD7D217C@onramp.net>
X-Deja-AN: 693367387
Content-Transfer-Encoding: 7bit
References: <3a0c4fc5$1_2@dnews>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Trace: 13 Nov 2000 22:09:53 -0800, 209.86.74.124
Organization: TeamB
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier

Reply to Parent Message