Set Default Charset And Collation On Table Creation

[BobW]

How do I get SQLyog to set the default character set and collation when I create a new table? The Advanced Properties dialog has a number of properties, but nothing concerning these two.

Thanks!

[peterlaursen]

Specifying charsets/collations different from upper-level (server or database) default with CREATE DATABASE and CREATE/ALTER TABLE is not yet supported from SQLyog GUI. We plan to add this in version 6.1 (first beta maybe by end of next week allready).

Untill then you will have to create (or alter) table using SQL like for instance:

Code:

CREATE TABLE mytable COLLATE

You can also (now already) define collations for individaul columns

Once the table is created you can ALTER TABLE from GUI and add more columns, indexes etc.

Also note that ALTER TABLE …. COLLATE .. does not change the charset/collation of existing columns.

… OK .. agreed. I little bit silly maybe that we untill now supported (non server-default) charset/collations definitions for COLUMNS and not for DATABASES and TABLES. But it not not because of this post that it is coming now .. we decided that more than a month ago!

[BobW]

I'm glad to hear that it's close on the roadmap – I look forward to its inclusion. In the mean time, I'll just keep doing it manually.

[Author]

Posts