Forum Inserting a non-escaped backslash character into MSSQL with Eloquent

adietz

posted 10 years ago

Database Eloquent

Last updated 2 years ago.

adietz

replied 10 years ago

It's a hokey workaround, and I still hold out for the "right" way to do this, but I managed to get this working by converting the password value to a hex value and sending that value to the sql server, then decrypting it there.

$password =  bin2hex( 'encryptedpasswordstring' );
        
$results = DB::update("update Users set 
    Password = convert(varchar, 0x" . $password . ") 
    where UserID = ?", array($userid);

Last updated 2 years ago.