Seek-One/opendbviewer

UTF-8 Issue

lebouquetin opened this issue · 0 comments

On debian 9, I have a database encoded in UTF8 and a table defined as follow (instructions taken from opendbviewer):

CREATE TABLE `links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source` varchar(2048) COLLATE utf8_bin NOT NULL,
  `target` varchar(2048) COLLATE utf8_bin NOT NULL,
  `text` varchar(1024) COLLATE utf8_bin NOT NULL,
  `weight` float DEFAULT '1',
  `nofollow` tinyint(1) DEFAULT NULL,
  `disallow` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 COLLATE=utf8_bin

When showing data I get wrong encoded strings. When connecting from mysql CLI client, I get the right content.