Vincit/knex-db-manager

No information on collation / charset

Closed this issue · 5 comments

jonnysmith1981 commented

Using the following dbManager config:

  dbManager: {
    // db manager related configuration
    collate: ['latin1_swedish_ci'],
    superUser: user',
    superPassword: 'password'
  }

Gives

ER_COLLATION_CHARSET_MISMATCH: COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'

But there's no information on how to provide the character set

elhigu commented

what DB are you using? if it is mysql check mysql drivers documentation.

jonnysmith1981 commented

I dont understand. I want to know how this library allows me to specify the character set.

elhigu commented

It depends on database that you are using. Please tell me what DB are you using? This library doesn't define any common way to do it.

jonnysmith1981 commented

Ah ok, i'm using MySQL (technically I'm using MariaDB with the MySQL library).

Just as a side thought, does this mean that knex-db-manager only currently supports Collations that use UTF-8 charsets?

elhigu commented

Just as a side thought, does this mean that knex-db-manager only currently supports Collations that use UTF-8 charsets?

No. It does not.

Here is mysql driver configuration option for setting charset listed

https://github.com/mysqljs/mysql#connection-options

Let me know if it doesn't work. I haven't personally used knex-db-manager mysql's collation setting (it was not contributed by me). But if utf8 collations work I cannot think any reason why any other collation wouldn't.

  • 👍1