Re: trailing spaces

Ravi Tallury wrote:

> Hi
> When i do a
> select '1' from dual from one instance of the database, i get only a
> single chanrecter.
>
> However when i run the same query from an other instance, i get a
> blank padded string. This has been causing problems in our application
> because of logic we use, any help in figuring out the reason and the
> remedy would be quite helpful.
>
> Thanks
> Ravi

I would really like to know the origin of this problem; it seems very, very odd that a basic thing like select '1' from whatever would return anything else than '1'.

-- 
Regards, Frank van Bortel