[MDEV-10081] Feature request: ALTER DATABASE CONVERT TO CHARACTER SET , like ALTER TABLE CONVERT TO CHARACTER SET Created: 2016-05-18 Updated: 2016-05-18 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Character Sets |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | BitSmid | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
When working with 3rd party databases, the default character set of the database can get in the way when creating tables. It would be nice to be able to repair this by issuing a command like ALTER DATABASE database_name CONVERT TO CHARACTER SET encoding_name; And not have to do this for every table in the database separately, as the number of tables in a database can be rather large. The command above would then run the command ALTER TABLE table_name CONVERT TO CHARACTER SET encoding_name; On all tables in the given database. |