[MediaWiki-l] Hidden categories: page_props consistence
bozzolan.valerio at educ.di.unito.it
Thu Jul 20 20:25:22 UTC 2017
I only have noticed now the varbinary type. This explains the phpMyAdmin
Thanks, you made my day.
On 20/07/2017 03:25, Bartosz Dziewoński wrote:
> All text in MediaWiki's database uses MySQL's "BINARY" encoding by
> default, even though it's encoded in UTF-8, for historical reasons
> (MySQL's UTF-8 support used to be horribly broken).
> The software you're using to view it therefore decides to show you the
> binary bytes, rather than the actual text. I've seen this annoying
> behavior in some versions of PHPMyAdmin and MySQLWorkbench, I don't
> know what you're using.
> You can "decode" the value '68696464656e636174' based on the ASCII
> values for the hex codes:
> 0x68 = 'h'
> 0x69 = 'i'
> 0x64 = 'd'
> 0x64 = 'd'
> 0x65 = 'e'
> 0x6e = 'n'
> 0x63 = 'c'
> 0x61 = 'a'
> 0x74 = 't'
> Or, you can cast it to the 'char' type in your query to make your
> software behave:
> SELECT CAST(pp_propname as char) FROM page_props;
> The actual data stored in your database has been 'hiddencat' all along,
> and MediaWiki doesn't need to do anything special to get that. The
> problem is with the viewer software being too clever.
Email sent from Ubuntu GNU/Linux GNOME using Mozilla Thunderbird
(Don't fight about it. I have to convert this client to Debian stable, like my laptop)
More information about the MediaWiki-l