Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: added example for table create


And setting your default charset and collation in your my.cnf file

Or you can set these things at table create as below. One can also set these on the database as a whole.

mysql> show create table cards \G
*************************** 1. row ***************************
       Table: cards
Create Table: CREATE TABLE `cards` (
  `pk` int NOT NULL,
  `creator_pk` int DEFAULT NULL,
  `created_date` bigint DEFAULT NULL,
  `invalid_date` bigint DEFAULT NULL,
  PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Fonts & CSS

Different fonts may not have all the characters to display the different characters. If you're using a default stylesheet, then the browsers may be displaying differently simply because of fonts. Speaking of stylesheets, you probably want to encode that in UTF-8 also. Start your stylesheet with something like