Level 122
Read https://www.sqlite.org/datatype3.html and the section on Type Affinity
I'm trying to make it work my tests on SQLite, but I always the same error :
PDOException: SQLSTATE[HY000]: General error: 20 datatype mismatch
I looked at the structure in SQLite, and I noticed that all my bigInteger in my migration files are integer in SQLite.
On MySQL, everything work, but it's slower.
Here are my migration file :
public function up()
{
Schema::create('hotels', function (Blueprint $table) {
$table->bigInteger('id')->unsigned()->primary();
$table->string('name');
$table->string('shortname', 4);
$table->timestamps();
$table->softDeletes();
});
}
BTW I'm on Laravel 5.6.16.
Please or to participate in this conversation.