Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: When did VARCHAR2 columns store trailing spaces?

Re: When did VARCHAR2 columns store trailing spaces?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 09 Jun 2006 07:19:16 +0200
Message-ID: <n41i82p5d0070sueivpad17u03clet5krn@4ax.com> 





On 8 Jun 2006 20:34:47 -0700, "fitzjarrell_at_cox.net"
<fitzjarrell_at_cox.net> wrote:



>Yes, the formatting isn't the best, but note the trailing spaces I

>submitted to Oracle remain in the stored value.  I remember when this

>didn't occur; I'm wondering when this 'broke' and if there is a fix.





Oracle doesn't pad automatically.


However, I don't think Oracle ever trimmed redundant spaces *supplied*
in an INSERT statement.


--
Sybrand Bakker, Senior Oracle DBA


Received on Fri Jun 09 2006 - 00:19:16 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US