Mysql pads PGP keys with zeros if they are less than 16 characters

[MarkDDR]

Example: CAFEBABE -> CAFEBABE00000000
nil -> 0000000000000000

[alexander-bauer]

It really shouldn't do that. GPG will interpret this very incorrectly, and try to use the key of id CAFE BABE 0000 0000 rather than xxxx xxxx CAFE BABE. The latter scheme, though 8 digits, is valid, because it's the rightmost 8 digits of the key ID. Even 0000 0000 CAFE BABE is wrong, unfortunately, because then it will interpret that as a 16 character ID.

MySQL makes me very sad.

[MarkDDR]

This is expected behaviour in MySQL http://dev.mysql.com/doc/refman/5.0/en/binary-varbinary.html

There are a couple of solutions to this.

1. Use VARBINARY instead of BINARY because MySQL doesn't pad VARBINARY with 0x00 on insert.
2. Detect if there are 8 trailing zero's and automatically strip them

[lukevers]

Does SQLite3 and everything else we support (I think mariadb also is supported) use VARBINARY? If so, that sounds like a viable option.

[lukevers]

Upon searching sqlite's site for VARBINARY, I get no response.

No results for: VARBINARY

Upon searching sqlite's site for BINARY, I get a response.

Search results 1..10 of 70 for: BINARY

I only searched for BINARY to make sure that they did have that documentation on their site.

[lukevers]

Another option is to just use VARCHAR. I'd rather not do anything right now until we get opinions from people.

[dansup]

I'd say VARCHAR.

[alexander-bauer]

I'm going to check exactly how they're stringified real quick. It's possible that this is more easily fixed in Go.