Setting Defaults

[peterlaursen]

However if you have defined server default as utf8/innodb databases and tables may have other defaults (for instance if you have imported your data from an older installation using latin1/myisam.  Server/database character settings for charset are only defaults. As are server/database settings for storage engine. The defaults may always be overridden at lower level (ie: you can have a latin1 table in a database that has default utf8).

SQLyog will dump data as they are stored.  All backup tools will. The setting in SQLyog 'secheduled backup' is a setting of how the exported file shall be encoded ONLY.  The interactive export tool will always use utf8-encoding. Only if you need to read the file in some non-unicode editor you will need to use this option. 

[Junk1958]

Interesting.

I have looked in my SQLyog (v 8.2) and I see under Table->More Table Operations->View Advanced Properties that there is a value for Engine for each table. It also seems to give me the ability to change the engine type for the table. This is good.

However, on the same tab, I do not see anything about char set, although I do see what looks to be a particular char set listed under Collations. Is Collation the right thing to look at?

And how would I use SQLyog to change/convert the data in the table to utf8?

Lastly, I looked under database for similar information/operations on the databse itself. However, I do not see anything similar. How would I see what the defaults are for the database and how would I change them using SQLyog?

Thanks kindly!

[peterlaursen]

The option to change charset is is ALTER TABLE .. advanced properties.  Also if you write a SQL statement you will writhe ALTER TABLE tablename CHARACTER SET … “.  

[attachment=1358:charset.jpg]

'View advanced properties' is read-only information.  The charset is implicitly described by the collation. 

[Junk1958]

Thank you.

[Author]

Posts