UTF-8 Issue
lebouquetin opened this issue · 0 comments
lebouquetin commented
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.