> "Guru" == Guru Prasad <[EMAIL PROTECTED]> writes:
Guru> the field 'id' is of type CHAR(5). I didn't get any records (
Guru> when i am sure that the data is available for '1001' ). If i
Guru> changed the data type to VARCHAR(5), it is working fine. Why is
Guru> it so ?
This is indeed becomi
Prasad" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 5:09 AM
Subject: RE: Problem with CHAR Data Type in ORACLE
> It sounds like the trailing blanks are causing it to not match. I know MS
> SQL has a rtrim() function. do you have anything c
o the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
> -Original Message-
> From: Guru Prasad
> To: [EMAIL PROTECTED]
> Sent: 02/26/2001 10:59 PM
> Subject: Problem with CHAR Data Type in OR
Sterin
-Original Message-
From: Guru Prasad
To: [EMAIL PROTECTED]
Sent: 02/26/2001 10:59 PM
Subject: Problem with CHAR Data Type in ORACLE
Dear Friends,
I am unable to get any records using SELECT command. I tried the
following
SQL statement.
"select name from junk where id
s MS Syntax, but I'm sure Oracle will have a similar way of doing it.)
Steve Howard
-Original Message-
From: Guru Prasad [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 11:59 PM
To: [EMAIL PROTECTED]
Subject: Problem with CHAR Data Type in ORACLE
Dear Friends,
I am
Dear Friends,
I am unable to get any records using SELECT command. I tried the following
SQL statement.
"select name from junk where id='1001'"
the field 'id' is of type CHAR(5). I didn't get any records ( when i am
sure that the data is available for '1001' ). If i changed the data ty
