SET @entityid = 5; -- category's ID

-- Select varchar/string based category attribute values
SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'varchar' AS 'type'
FROM catalog_category_entity e
  JOIN catalog_category_entity_varchar eav ON e.entity_id = eav.entity_id
  JOIN eav_attribute ea ON eav.attribute_id = ea.attribute_id
WHERE e.entity_id = @entityid
-- Select integer based category attribute values (includes boolean values)
UNION(
  SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'int' AS 'type'
  FROM catalog_category_entity e
    JOIN catalog_category_entity_int eav ON e.entity_id = eav.entity_id
    JOIN eav_attribute ea ON eav.attribute_id = ea.attribute_id
  WHERE e.entity_id = @entityid
)
-- Select decimal based category attribute values
UNION(
  SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'decimal' AS 'type'
  FROM catalog_category_entity e
    JOIN catalog_category_entity_decimal eav ON e.entity_id = eav.entity_id
    JOIN eav_attribute ea ON eav.attribute_id = ea.attribute_id
  WHERE e.entity_id = @entityid
)
-- Select datetime based category attribute values
UNION(
  SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'datetime' AS 'type'
  FROM catalog_category_entity e
    JOIN catalog_category_entity_datetime eav ON e.entity_id = eav.entity_id
    JOIN eav_attribute ea ON eav.attribute_id = ea.attribute_id
  WHERE e.entity_id = @entityid
)
-- Select text based category attribute values
UNION(
  SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'text' AS 'type'
  FROM catalog_category_entity e
    JOIN catalog_category_entity_text eav ON e.entity_id = eav.entity_id
    JOIN eav_attribute ea ON eav.attribute_id = ea.attribute_id
  WHERE e.entity_id = @entityid
);