Developer

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Thomas Lauria

Saved on

compared with

New Version 2

changes.mady.by.user Thomas Lauria

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
titleChange the default character set and collation of a database:
ALTER DATABASE <database_name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Additional Errors produced due the missing charset:

Code Block
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', query was: