Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
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.