> Here is a description of the testcase for the problem:
>
> Oracle:
> Create table Mytable (
> Username varchar2(20),
> Passwd varchar2(20),
> Usertype varchar2(50))
So, why are you using VARCHAR2 for this case? If you used
the simple VARCHAR for all of your columns this problem
would not occure?!
>
> 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.
>
> 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!
>
> Victoria
>
Benjamin
--
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]
