search

laminas / laminas-db

Database abstraction layer, SQL abstraction, result set abstraction, and RowDataGateway and TableDataGateway implementations
https://docs.laminas.dev/laminas-db/
BSD 3-Clause "New" or "Revised" License
122 stars 68 forks source link

Ddl Missing support for character set / encoding #235

Open FalkHe opened 2 years ago

FalkHe commented 2 years ago

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