I don't remember doing anything out of the ordinary, but I suddenly realised a boolean column in my database (which I created with $table->boolean('isOnline')->nullable(); method) stores true or false as "on" text, not 1.
When I search for ->where('isPublic', true)->get , it finds nothing.
Have I missed something?
Last updated
3 years ago.
what database type are you using? If MySQLm double check your column type... you must have done something wrong because boolean() creates a tinyint(1)
Last updated
3 years ago.
Ok thanks. Then it is maybe related to SQLite? Because I did indeed create a boolean.
Last updated
3 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast