distal-attribute
distal-attribute
distal-attribute
distal-attribute

Field Collation column disappeared

User, date Message
Written by gnulp
4 years ago
Category: General
2 posts since Sat, 17 Jul 10
I'm always using the latest nightly build and some versions ago I noticed that the column which displays the field follation in the table editor has gone. in 5.1 release and in some later builds it still was there...
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
Yes, right. The collation column is just hidden since I introduced a new column inbetween "Zerofill". I'll add a popup menu for right clicking the column headers which will allow you to hide/unhide columns.
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
Please update to r3457 - there you can right click the column headers to show all columns again.
Written by gnulp
4 years ago
2 posts since Sat, 17 Jul 10
it works. perfectly. thank you.
Written by Rapid-eraser
4 years ago
34 posts since Wed, 23 Jun 10
Shouldn't these fields show the stored collation ?
Both is column and the Default collation in the table options are not showing the stored value to my installation.
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
As said above, the collation column was hidden since the zerofill column was introduced recently. To show the collation column again, you need to update to the latest build, and then rightclick the column headers.
Written by Rapid-eraser
4 years ago
34 posts since Wed, 23 Jun 10
I can see the collation column , I was wandering if there were supposed to show the stored value of the collation like when accessing data to the database tab (where the collation of each table is shown )

smile
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
Ah, I see. That's the "Default collation" pulldown on the "Options" tab (the second tab, besides "Basic"). See it?
Written by Rapid-eraser
4 years ago
34 posts since Wed, 23 Jun 10
Yes both is pulldown and the column "Collation" inside the table tab are refusing to show the stored collation as opposed to the "Database:" tab that the same column stored collation is shown currently.

Is this some thing happening only in my installation ?

Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
Hm, also here empty on some tables, but most show their collation. Probably the SHOW CREATE TABLE result does not reveal the collation. If you want you can post the SHOW CREATE TABLE xyz result here, so we can analyze that.
Written by Rapid-eraser
4 years ago
34 posts since Wed, 23 Jun 10
Ok here relays the problem,

As I can see in the mysql manual

<quote>
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
Important

The original CREATE TABLE statement, including all specifications and table options are stored by MySQL when the table is created. The information is retained so that if you change storage engines, collations or other settings using an ALTER TABLE statement, the original table options specified are retained. This enables you to change between InnoDB and MyISAM table types even though the row formats supported by the two engines are different.

</quote>

The "SHOW CREATE TABLE" for what I understand provides only info that is compatible to all storage engines and mysql versions

You can use the "SHOW FULL COLUMNS FROM `xyz`"

to retrieve the needed info plus the missing info.


By the way the respond to the CREATE TABLE statement for my case is:


CREATE TABLE `markers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL,
`address` varchar(80) NOT NULL,
`lat` float(10,6) NOT NULL,
`lng` float(10,6) NOT NULL,
`type` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8
Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
Default collation pulldown should be fixed in r3460, now there is a fall back to take it from the SHOW TABLE STATUS when missing in SHOW CREATE TABLE result. Only the collation attribute for single columns will stay empty, which means these are using the default collation.
Written by Rapid-eraser
4 years ago
34 posts since Wed, 23 Jun 10
Thanks for the Default collation now its working smile

I still have a problem with the single columns collation.

If I change a collation to a column as greek_general_ci the "SHOW CREATE TABLE xyz" will report the column as 'greek' incorrectly and the column probably wont match the contained collations and stays empty, giving the false impression that it is the default collation.

This mainly happens because as said before the "SHOW CREATE TABLE xyz" tries to produce a compatible sql query that would me honored from all mysql versions.
 

Please login to leave a reply, or register at first.