Question : I’m just wondering because MySQL ENUMs are essentially tied to the table, how do they handle JOINs if […]
Tag: enum
Mysql: Any way to properly index 3 ENUM columns with the same options ? (A OR B OR C)
Question : I have 3 enum() columns with the same option values inside. I first tried to use the “set” […]
Can I alter ENUM value from lowercase to studlyCase without reindex?
Question : I have a several big tables, and enum in each of them (example): ENUM (‘webmasters’, ‘stackexchange’, ‘stackoverflow’) Documenation […]
How does MariaDB handle ENUM types used in FOREIGN KEY constraints?
Question : Off the heels of this question, How does MySQL handle joins on ENUMs? How does MySQL work if […]
Is it a bad practice to query pg_type for enums on a regular basis?
Question : In Postgres, I’m thinking of query pg_type for an up-to-date list of enumerations I’m using on a regular […]
Does the collation of ENUM columns impact their size?
Question : What does it mean when we say that an ENUM has a charset of utf8mb4, versus latin1? My […]
PostgreSQL ignores implicit casts in some situations
Question : The setup (tried only on PostgreSQL 9.6): CREATE TYPE MY_ENUM AS ENUM (‘a’, ‘b’); CREATE CAST (CHARACTER VARYING […]
Using PostgreSQL to hold an array of data
Question : I am trying to use a postgreSQL data base column to store values from an array (or point […]
How does MariaDB handle joins on ENUMs?
Question : I’m just wondering because MySQL ENUMs are essentially tied to the table, how do they handle JOINs if […]
How do I query PostgreSQL enums like in MySQL?
Question : With the following table in MySQL: CREATE TABLE bob(foo ENUM(‘a’,’b’,’c’)); INSERT INTO bob (foo) VALUES (‘a’),(‘b’),(‘c’),(‘a’),(‘a’); SELECT * […]