Traling spaces in result?

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 - 14:26:13 CET