sqlsrv updates not working

[ChrisSantiago82]

I have a very strange issue with sqlsrv. Creating a new model and save it to the database works. Updating it, not anymore.

Query gets executed, without any errros, just the data are not being updated. Only way I could make it work if I interact directly with the pdo. Because of this, I think everything is set up correctly, with the odbc and the database settings. And retrieving data also works like a charm. Just updates won't happen.

I have tried the following:

$mitgliederstamm = Mitgliederstamm::findOrFail('32862 ');
$mitgliederstamm->AnredeID = 2;
$mitgliederstamm->save();

Mitgliederstamm::where('MitgliedsNr', '=', '32862 ')
->update(
[
'AnredeID' => 2,
]
);

DB::connection('sqlsrv')
->update(DB::RAW("UPDATE Mitgliederstamm SET AnredeID = 2 WHERE (MitgliedsNr = '32862 ')"));

Here with the raw query, if I build in a syntax error, I'm getting a syntax error from the database. That means it's talking to the database. It's just not updating the data.

$pdo = DB::connection('sqlsrv')->getPdo();
$query=$pdo->prepare("UPDATE Mitgliederstamm SET AnredeID = 2 WHERE (MitgliedsNr = '32862 ')");
$query->execute();

If I work directly with the pdo, then the same query works fine and the data is being updated.

That is how the model looks like:

class Mitgliederstamm extends Model
{

protected $connection = 'sqlsrv';

protected $table = 'Mitgliederstamm';

protected $primaryKey = 'MitgliedsNr';

protected $keyType = 'string';

public $incrementing = false;

public $timestamps = false;

Does anybody has any idea?

[Angel5a]

You have an extra space in '32862 ' at the end with a primary key declared as a string. Strings '32862 ' and '32862' won't match. Perhaps that's the reason.

[ChrisSantiago82]

Thank you. The data I'm trying to change also have that space.
I also have tried to remove it and still didn't work.

And findorfail also works with the space.
And if I use the same query directly with pdo, it's also working

[Angel5a]

Can't see anything wrong. Try to debug it. you can use dump() thru the library code. I don't have sqlsrv myself.