Traling spaces in result?

From: Ken1 <ken1_at_tjohoo.se>
Date: 17 Feb 2004 05:26:13 -0800
Message-ID: <3bb6578e.0402170526.7f3cc1e1@posting.google.com>

Why is it that rows returned from this statement have extra trailing spaces?
I.e. today tuesday the returned string is "Tuesday " with the length 9.

SELECT TO_CHAR(SYSDATE, 'Day','nls_date_language=english'), LENGTH(TO_CHAR(SYSDATE, 'Day','nls_date_language=english')) FROM dual

I am using oracle 8.1.7

I read somewhere on the internet that FM (Format Models?) could solve this problem I have, but I thought that the 'Day' was the actual FM.

I have temporary solved it using trim() but if I do a compare between this and a column in the database I don't want to use trim() everywhere.

Any other good solution.

/Ken1 Received on Tue Feb 17 2004 - 07:26:13 CST