Sorry, it was a mistake on my side. I just figure out why the string
comparisons between CHAR and VARCHAR2 didn't work for me. When I first
inserted data to Mytable, I had CHAR(20) defined for all columns. Later I
alter it to VARCHAR2(20), but the original 20 characters were already in the
database. Therefore I was using the 20 character string for the comparison.
Sorry for the confusion.
Victoria
> -----Original Message-----
> From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 27, 2001 1:09 PM
> To: Victoria Zhou
> Cc: Thies C. Arntzen; [EMAIL PROTECTED]
> Subject: Re: [PHP-INST] PHP datatype vs Oracle Varchar2
>
>
> On Thu, Jul 26, 2001 at 07:27:07PM -0500, Victoria Zhou wrote:
> > Here is a description of the testcase for the problem:
> >
> > Oracle:
> > Create table Mytable (
> > Username varchar2(20),
> > Passwd varchar2(20),
> > Usertype varchar2(50))
> >
> > Insert into Mytable (Username, Passwd, Usertype)
> > values('tester1','tester1','Operator');
> >
> > PHP:
> > $sql = "select * from Mytable where Username='tester1'";
> > $sql_statement = OCIParse($conn, $sql) or die ("Couldn't parse
> statement");
> > OCIExecute($sql_statement) or die ("Couldn't execute query");
> >
> >
> > Problem:
> > The string comaparison in the $sql (Username='tester1') is never true,
> > because Username is a variable length string and 'tester1' is
> considered as
> > a fixed length string.
>
> wrong - that should not be the case.
>
> >
> > I don't have the flexibility to change VARCHAR2 to CHAR in order to make
> > this work, because a fixed length string will cause a lot of trouble for
> > string comparisons for other code in the program.
> >
> > Thanks for your help!
>
> i did the same thing (i hope) and it woorsk for me. i see no
> reason why it shouldn't work. there is _no_ reason to switch
> to from varchar to char!
>
> please try to do the _same_ select-statement in sqlplus -
>
> tc
>
> >
> > Victoria
> >
> >
> >
> >
> > > -----Original Message-----
> > > From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, July 26, 2001 6:10 PM
> > > To: Victoria Zhou
> > > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > > Subject: Re: [PHP-INST] PHP datatype vs Oracle Varchar2
> > >
> > >
> > > On Thu, Jul 26, 2001 at 05:08:42PM -0500, Victoria Zhou wrote:
> > > >
> > > > Hi,
> > > >
> > > > The comparison between Oracle VARCHAR2 and a PHP string
> doesn't seems to
> > > > work. Detail as follows:
> > > >
> > > > I have one PHP variable and one Oracle column:
> > > > . $form_user_id: a PHP string obtained from web form input,
> > > such as 'user1'.
> > > > . Username: an oracle table column of type VARCHAR2(20).
> > > >
> > > > The following sql statement failed:
> > > > "select * from mytable where Username='$form_user_id'"
> > > >
> > > > It failed because Username has a strlen of 20, where
> $form_user_id has a
> > > > strlen of 5. If I changed the Username from VARCHAR2(20) to
> > > CHAR(20), then
> > > > this sql worked fine. But I think with Oracle VARCHAR2, the
> strlen of
> > > > Username in this case should be 5 instead of 20.
> > >
> > > you must be doing something wrong here;-)
> > >
> > > please try to create a _tiny_ testcase (< 20 lines) and post
> > > it to the list, i'm sure you're overseeing something
> > > important.
> > >
> > > tc
> > >
> > >
> >
>
>
--
PHP Install Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
