How Can I Change Default Encoding

[Killer_B]

I don't know how to change default encoding for single table. When I create new table the default encoding is set to latin2. If I choose to alter the table I can't change the encoding.

[peterlaursen]

Just first create the table using default, next rightclick table .. change tabletype

We will support defining an ENGINE with create database, create table and alter table soon.

[Killer_B]

I changed tabletype but it doesn't make any difference. I still don't get right encoding. I would like to use utf-8 character set for whole table. I can set right character set in columns but it's not working because of the character set of the table.

[peterlaursen]

Quote:

I still don't get right encoding.

Table type/engine and encoding/charset are two different things!

You asked how to change the table TYPE, but to change the CHARSET in MySQL execute for instance

Quote:

ALTER mytable default charset utf8

But note that this is not affecting existing columns in that table.

Only new columns created after that will be affected.

Also this we plan to support from the GUI (CREATE TABLE and ALTER TABLE).

[Killer_B]

Yes I think that would be the right solution, but since I'm obviously complete newbie I don't know where and how can I execute this sql command.

I found only mysql restore and backup command in DB menu.

[peterlaursen]

Quote:

I don't know where and how can I execute this sql command.

Just execute from the SQLyog Query Editor.

[Killer_B]

I'm very sorry that I keep bothering you, but it seems that utf8 isn't right character set for what I need. I need Slovenian character set. In html I use windows-1250 encoding which is central european but I can't find this encoding in sqlyog.

Thanks again

Nevermind I found solution in latin2 character set.

Again, thank you very much!

[Author]

Posts