I suggest you...

Ability to display values of Binary columns as GUIDs

In MySQL studio the primary keys (binary(16)) are displayed as binary(example: "�J���/�H��>�}�'�" and not the GUID (example: "{a3884a8b-2fc0-48f0-95a8-3edd7d9527e9}").
I understand that it is not possible for MySQL studio to "know" that a Binary(16) is not just binary data, but a GUID.

In PHP there is a function to "decode" a GUID and display it as a string. The function is called "mssql_guid_string" (http://php.net/manual/en/function.mssql-guid-string.php ).
It would be nice to specify somewhere that all binary(16) fields are actually GUIDs and not just binary data. Something like "treat Binary(16) as GUID".

35 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    MartijnMartijn shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Chris HynesChris Hynes commented  ·   ·  Flag as inappropriate

        Been awhile on this one, but very useful. Any progress toward this with the new visualizers?

      • KevinKevin commented  ·   ·  Flag as inappropriate

        I would like to see this as well. We use varbinary(16) to represent 32 character UUIDs (with no dashes) for things like primary keys and id fields.

        Having the data grid automatically HEX() the value on read and UNHEX() on save would be a great feature to have. In other words, it would be nice to be able to see the hex UUID in the cells rather than a bunch of garbled characters.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Toad for MySQL does this automatically (in case that provides any extra motivation to get it done!)

      • AnonymousAnonymous commented  ·   ·  Flag as inappropriate

        I would like to see unified GUID handling not only in MySql, but in Oracle and Firebird as well.

      • LukaLuka commented  ·   ·  Flag as inappropriate

        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

      Feedback and Knowledge Base