Developer

Page tree

Versions Compared

Old Version 2

changes.mady.by.user Thomas Lauria

Saved on

compared with

New Version 3

changes.mady.by.user Aleksandar Mitrev

Saved on

Key

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

...

Code Block
languagesql
titleGet all columns not configured as UTF8utf8mb4:
SELECT TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLLATION_NAME,CHARACTER_SET_NAME from information_schema.columns where CHARACTER_SET_NAME != 'utf8utf8mb4';


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;

...