Insert binary value into table fails.

That's a HEX right? You need to use hex2bin before inserting it into your DB. And bin2hex to return it from the database.
I'm using BINARY(16) for storing UUID to get a faster JOINS. But why do you need to store password in BINARY?

PHP Code:

if ( ! function_exists('UUID_TO_BIN'))
{
    function UUID_TO_BIN($uuid) {
        $uuid = hex2bin(str_replace('-','',$uuid));
        return $uuid;
    }
}

if ( ! function_exists('BIN_TO_UUID'))
{
    function BIN_TO_UUID($uuid) {
        if( empty($uuid) ) return;
        $uuid = bin2hex($uuid);
        $uuid = substr($uuid, 0, 8) . '-' . substr($uuid, 8, 4) . '-' . substr($uuid, 12, 4) . '-' . substr($uuid, 16, 4)  . '-' . substr($uuid, 20);
        return $uuid;
    }
}