3 ms·
I use utf8mb4 with binary collation as a default. When I then get to a column type like email, I don't know what I should use. Dropping down to 7-bit case-ins
by jcampbell1 12y ago
I use utf8mb4 with binary collation as a default.
When I then get to a column type like email, I don't know what I should use. Dropping down to 7-bit case-insensitive sounds plausible, but another option would be to stick with utf8mb4 but case-insensitive?
Is there a best practice?
- crazygringo 12y agoI almost exclusively use utf8mb4_bin (for "human" text) and ascii_bin (for ID's or other "computer" text) -- they're basically the two 'extremes', and it's rare to need anything in between. And then other collations like case-insensitive or accent-insensitive only when required, e.g. because the field is used for search.