A very good idea. We also store .Net GUID in MySql. It would be nice to see a kind of a feature like in phpMyAdmin for transforming the view of the fields. This can be usefull not only for GUID's in this example, but for all kind of data (view) transformation:
So I believe it would be the best if a user could define how to transform specific fields in the view grid, instead of saying that Binary(16) should always be treated as a GUID. MySql connector recently changed the GUID storage from Binary(16) to char(36), with an option to force the use of Binary(16) through a param in the connection string. Therfore it would be better if the user could define the treansformations in a simple way.
Of cours, also a list of predefined transformations is always welcome.
Luka
supported this idea
·
A very good idea. We also store .Net GUID in MySql. It would be nice to see a kind of a feature like in phpMyAdmin for transforming the view of the fields. This can be usefull not only for GUID's in this example, but for all kind of data (view) transformation:
http://www.phpmyadmin.net/documentation/Documentation.html#transformations
So I believe it would be the best if a user could define how to transform specific fields in the view grid, instead of saying that Binary(16) should always be treated as a GUID. MySql connector recently changed the GUID storage from Binary(16) to char(36), with an option to force the use of Binary(16) through a param in the connection string. Therfore it would be better if the user could define the treansformations in a simple way.
Of cours, also a list of predefined transformations is always welcome.
cheers!
K