New answers tagged

0

When declaring HEX strings such as UUIDs, or when declaring other strings with limited character set needs, such as country_code, postal_code, zip_code, etc, declare them to be CHARACTER SET ascii. It can be applied just to the column, letting the rest of your columns be utf8mb4 or whatever. And be consistent between tables so that JOIN works efficient. ...


0

Stored Procedures also have a collation defined Here is mysql.proc mysql> show create table mysql.proc\G *************************** 1. row *************************** Table: proc Create Table: CREATE TABLE `proc` ( `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `name` char(64) NOT NULL DEFAULT '', `type` ...



Top 50 recent answers are included