laravel-firebird
laravel-firebird copied to clipboard
% wildcard counting in column length
I'm using Laravel 9 and I have a query that does a where like to a column varchar(14).
When the like has the full length of the column I get a error saying it expected 14 and got 16 characters.
Example: where document like '%12345678901234%'
When I do the same query in the console it works, but when the Laravel does it doesn't.
Is this behavior normal? I'm kinda new to Firebird...
Giving a bit more context:
Using PDO it works:
Update:
Using whereRaw worked.
Will keep using it for now but curious as to why it doesn't work with where, maybe something when the params are bind?
I tried looking at the code but I'm not skilled enough yet for this task.