Database Migrations - The charset and collation properties.

Hello everyone!

Is it possible to set in CI4: "charset" and "collation" for the table, and more specifically for the columns?

For example, I have a table:

Code:

CREATE TABLE `user_test` (
/// Other columns...
  `mini_info` varchar(45) COLLATE utf8mb4_bin DEFAULT NULL,
  `user_description` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

The migration file looks like the following (immediately adds what I tried to add in the array to get the appropriate collation and charset):

PHP Code:

<?php
namespace App\Database\Migrations;

use CodeIgniter\Database\Migration;

class CreateUserTest extends Migration
{
    public function up()
    {
        $this->forge->addField([
            // Other columns...
            'mini_info' => [
                'type' => 'VARCHAR',
                'constraint' => 45,
                'null' => true,
                'charset' => 'utf8mb4',
                'collation' => 'utf8mb4_bin'
            ],
            'user_description' => [
                'type' => 'TEXT',
                'null' => true,
                'charset' => 'utf8mb4',
                'collation' => 'utf8mb4_general_ci'
            ]
        ]);

        $this->forge->addKey('id', true);
        $this->forge->createTable('user_test');
    }

    public function down()
    {
        $this->forge->dropTable('user_test');
    }
} 


Unfortunately, this does not work, I could not find any information about it in the documentation or on the Internet.

PS:
I would like to inform you that my post is not about setting "charset" and "collation" in files: "app/Config/Database.php" or .env
Pls help or advice on how to approach this.