laminas-db icon indicating copy to clipboard operation
laminas-db copied to clipboard

Ddl Missing support for character set / encoding

Open FalkHe opened this issue 3 years ago • 0 comments

Feature Request

Q A
New Feature yes
RFC not sure
BC Break no

Summary

I'm missing the ability to specify the default character set for tables and the character set for columns. I can't find anything to that in the docs nor in the code.

I need to create something like

CREATE TABLE `something` (
    `key` varchar(16) CHARACTER SET ascii COLLATE ascii_bin,
    `title` varchar(255) NOT NULL DEFAULT NULL,
    PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci

FalkHe avatar Dec 15 '21 08:12 FalkHe