Laravel 5.8 在“char”类型列迁移时出错

Question

你的观点是混乱的。首先添加表单操作然后添加按钮表单属性，如下所示：<button type="submit" form="upload" class="btn btn-info pull-right" id="submit" data-loading-text='SOME TEXT'> Please wait<?php echo $this->lang->line('save'); ?></button><form id="upload" role="form" method="post" class="ptt10" enctype="multipart/form-data" action="upload_docs">分享703507  703507  703507  我试图在 laraval 5.8 中使用 php artisan migrate 命令更改我的 char 类型列默认值，但出现以下错误：Unknown column type "char" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType(). You can get a list of all the known types with \Doctrine\DBAL\Types\Type::getTypesMap(). If this error occurs during database introspection then you might have forgotten to register all database types for a Doctrine Type. Use AbstractPlatform#registerDoctrineTypeMapping() or have your custom types implement Type#getMappedDatabaseTypes(). If the type name is empty you might have a problem with the cache or forgot some mapping information.我当前的脚本如下：use Illuminate\Support\Facades\Schema;use Illuminate\Database\Schema\Blueprint;use Illuminate\Database\Migrations\Migration;class AddTypeDeafultValueProjectsTable extends Migration{/** * Run the migrations. * * @return void */public function up(){    Schema::table('projects', function (Blueprint $table) {        $table->char('type', 50)->nullable(true)->change();    });}/** * Reverse the migrations. * * @return void */public function down(){    Schema::table('projects', function (Blueprint $table) {        //    });}}我没有遇到其他数据类型列的问题，但仅针对 char 出现上述错误。可以帮我解决这个问题吗？PHP数据库拉维laravel-5

Answer 1

您需要在迁移脚本中添加以下脚本：

在 use Illuminate\Database\Migrations\Migration 下或之上添加以下内容；

 use Doctrine\DBAL\Types\StringType; use Doctrine\DBAL\Types\Type;

之后在 inside up 函数中添加以下脚本并再次尝试 php artisan migrate。

    if (!Type::hasType('char')) {
        Type::addType('char', StringType::class);
    }