varchar vs char

[fernando.olmos at hpa.com.au]

Rob,

>From my experience with SQL Server 2000, if you entered a data item
directly into a varchar column using the Enterprise Manager, the column
naturally strips off the trailing spaces (or did it? Hmmm it's been a
few months now). I do admit, that if I passed the data item via another
field (say from ADO in VB) then it would retain the trailing spaces,
hence yes you would have to "trunc()" them yourself.

------------------------------

Message: 5
Date: Wed, 28 Sep 2005 19:00:28 +1000
From: "Robert Edis" <robeconsult at sbcglobal.net>
Subject: RE: varchar vs char
To: "PH List" <powerh-l at lists.sowder.com>
Message-ID: <000001c5c40b$12f72bc0$a6803dcb at BLUE>
Content-Type: text/plain;	charset="iso-8859-1"

varchar vs charAre you sure no Oracle RDBMS will load the trailing
spaces in this case?
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed.  If
you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************