VARCHAR2 and trailing spaces - what's going on!

From: dnh <nigel.hurst_at_food.ds-s.com>
Date: Mon, 30 Sep 2002 10:05:31 GMT
Message-ID: <3d982155.5881984@139.121.16.43>

Now then

I have always thought that when you insert a string into a varchar2 column any trailing spaces would be stripped off but am discovering that this is not so.

being a child of the net I then did a quick search to find both situations described as true - it does strip trailing spaces and it doesn't !!!!!!

I'm so confused and , well, confused - what is the truth, somebody help.

cheers

   nigel

---

Take out food to reply to nigel.hurst_at_food.ds-s.com

---

Received on Mon Sep 30 2002 - 05:05:31 CDT