Skip to content
This repository has been archived by the owner on Sep 27, 2022. It is now read-only.

sql error is coming on migration #39

Open
bradashfaq opened this issue Oct 19, 2020 · 1 comment
Open

sql error is coming on migration #39

bradashfaq opened this issue Oct 19, 2020 · 1 comment

Comments

@bradashfaq
Copy link

here is detail:

SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_unicode_ci' (SQL: select * fro
  m information_schema.tables where table_schema = db1 and table_name = migrations)
@lhsazevedo
Copy link

Hi @bradashfaq I think this is not related to the project. Can you check if your database software supports utf8mb4_unicode_ci collation?
If it doesn't, you can change it to a supported collation on config/database.php:

'collation' => 'utf8mb4_unicode_ci',

Or you use a database software that supports this collation (recommended).

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants