Re: VARCHAR2(1) vs CHAR(1)

Yes, I write "varchar".
But it's correct to specify it. :)

Marco

"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> ha scritto nel messaggio news:3d45972c.497596_at_news.jaapwvandijk.myweb.nl...
> On Sun, 28 Jul 2002 22:07:10 GMT, "Marco Muracchioli"
> <reply.on_at_group.please> wrote:
>
> ...
> >This mean that if you insert 'UGO' in a char(6) field, the result is
'UGO___'
> >with 3 spaces at end; if you do the same in a varchar one, the result is
'UGO'
> >with no spaces at end.
> >With varchar type trailing spaces are removed.
> ...
>
> This is NOT true for varchar2. For instance, if you assign 'UGO_' to
> a varchar2 field, the stored value will be 'UGO_'. The field is not
> padded with trailing spaces, but neither are trailing spaces removed.
>
> Jaap.
Received on Mon Jul 29 2002 - 16:15:23 CDT