RE: Different default 8i/9i column lengths when selecting pseudo columns...

From: Adams, Matthew (GE Consumer & Industrial) <MATT.ADAMS_at_GE.COM>
Date: Tue, 8 Feb 2005 10:30:08 -0500
Message-ID: <9E0E38DB4ACFAA4593AD6C4A45C9D5F009CF7237@LOUMLVEM01.e2k.ad.ge.com>

I have seen this behavior occur (different column lengths) when the databases are different character sets.

See if one database is using a multi-byte characters set (such as UTF8) and the other is using a single byte character set.

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi."

Larry Wall (creator of Perl)=20

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Thomas Day Sent: Thursday, February 03, 2005 10:49 AM To: CMarquez_at_aarp.org
Cc: oracle-l_at_freelists.org
Subject: Re: Different default 8i/9i column lengths when selecting pseudo columns...

Hi guy. My results, obviously on windows. Try a describe on dual and see if someone has renamed the column. I haven't been able to reproduce your results.

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

5 rows selected.

SQL> select 'xxxxx' from dual;

'XXXX

xxxxx

1 row selected.

SQL> col xxxxx format a20
SQL> select 'xxxxx' xxxxx from dual;

XXXXX

xxxxx

SQL> desc dual

 Name                                  =20
 -----------------------------------
 DUMMY                                 =20

SQL> col dummy format a20
SQL> select 'xxxxx' from dual;

'XXXX

xxxxx

1 row selected.
SQL> select 'xxxxx' dummy from dual;

DUMMY

xxxxx

1 row selected.

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 08 2005 - 10:33:11 CST