Re: [Sqlrelay-discussion] Problem with binary data in Oracle VARCHAR2 field using PHP

[David M. <dav...@fi...>]

Are the passwords getting truncated?

If so, they probably have NULL's in them.  sqlrcur_getField() will
return the data, but if it has a NULL in it somewhere, then if you use
string operations on it (such as getting the length), they will all bail
when they hit the first NULL.

There is a sqlrcur_getFieldLength() method that you should use when
dealing with binary data that should return the correct length.

That could be related to the issue you're having.

Another possibility is that the field may be getting truncated on insert
for a similar reason.  The NULL's may need to be escaped in the query,
or you might want to use bind variables.

If neither of these solutions seem applicable to your problem, then I'll
need to know some more details to be able to help further.

David Muse
dav...@fi...

On Fri, 2007-09-21 at 16:49 +0000, Daniel Smith wrote:
> We've been going back and forth with our IT people about using SQL
> Relay for a while now and in trying to convince them we've ported our
> implementation of PHP's oci8 pecl extension to sqlrelay.  The port
> took 2 days for one guy (included setting up a sqlrelay box) and is
> going quite well, but we're having one problem.  We store certain
> data, such as passwords, encrypted in the database and we can't seem
> to get it to retrieve the data properly.  I'll admit that our
> encryption/decryption functionality is somewhat of a blackbox, but we
> switch back and forth between the libraries and the only difference
> now is sqlrelay vs. oci8 extension.  Has anyone had any experience
> with this?
> 
>  
> 
> Thanks,
> 
> Daniel Smith 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion