Friend :
In my opinion, if you will use the ltrim(rtrim(column_char)) , i hope you
solve the problem.
Am i wrong ?
Eriovaldo
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 7:12 PM
Is there any overhead (ie. internal
If the varchar2 column is less than 2 chars then it will be padded with
blanks and THEN compared with CHAR column. That's all.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed
I want to add that even if you update a field to a *smaller* size, initial data
in the varchar2 column has to move to the empty space beyond the end of row
data inside the block, leaving a hole in its original place, just as if it were
updated to a longer string. Char data does not have this
Actually char has some minor performance advantages over varchar2 when the
column is frequently updated to a larger size since the full space is
already claimed within the block.
-Original Message-
Sent: Wednesday, August 29, 2001 6:58 PM
To: Multiple recipients of list ORACLE-L
Isn't
Terrian, Tom wrote:
I think that this subject comes up now and then, but I don't remember the
conclusions
We are creating a Data Warehouse and the subject of char vs varchar2 data types
came up. I searched google and found a little bit on the subject (mainly there
is no space
Thank you, I will check it out.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Wednesday, August 29, 2001 4:06 PM
To: Multiple recipients of list ORACLE-L
Terrian, Tom wrote:
I think that this subject comes up now and then, but I
One thing you have to consider is the comparison semantic when using
CHAR vs VARCHAR. You should consult the Oracle Doc on this.
[EMAIL PROTECTED] 08/29/01 03:35PM
I think that this subject comes up now and then, but I don't remember the
conclusions
We are creating a Data Warehouse
Isn't CHAR a declining feature, which is why Oracle is forcing the
conversion to VARCHAR2 whenever possible?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
