Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Column Character Set

forums › forums › SQLyog › Using SQLyog › Column Character Set

Tagged: 

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 11, 2014 at 1:37 pm #13231
      dany
      Member

      I’m using SQLyog 11.42 and MySQL 5.0.51.

      I have a problem editing a table that has different column character sets.

      (see MySQL manual  http://dev.mysql.com/doc/refman/5.0/en/charset-column.html)


      
CREATE TABLE `aaa` (
      
  `id` int(10) unsigned NOT NULL auto_increment,
      
  `bbb` varchar(100) character set latin2 NOT NULL,
      
  `ccc` varchar(100) NOT NULL default '',
      
  PRIMARY KEY  (`id`)
      
) ENGINE=InnoDB AUTO_INCREMENT=4313 DEFAULT CHARSET=utf8;

      If I press F6 in SQLyog there is no way I can see that column “bbb” has a different character set.

       

      How can I see different column character sets?

      How can I edit/change column character set?

       

      Best regards,

      Daniele

    • June 11, 2014 at 3:22 pm #34982
      sathish
      Member

      Hello Daniele,

       

      There is ‘Hide Language Options’ where charset and collation columns are hidden. You can uncheck the option to see the column charset and collation. Please find the screenshot attached.

       

       

      Regards,

      Sathish

    • June 11, 2014 at 3:38 pm #34983
      dany
      Member

      Hello Daniele,

       

      There is ‘Hide Language Options’ where charset and collation columns are hidden. You can uncheck the option to see the column charset and collation. Please find the screenshot attached.

       

       

      Regards,

      Sathish

       

      Hello Sathish,

      thank you very much!

       

      It works!

       

      Best Regards,

      Daniele

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.