[Haskelldb-users] Serious bug when handling binary data

[Volker W. <po...@vo...>]

Hi

I'm using haskelldb-0.8 in conjunction with MySQL. I have a table with a
column of type tinyblob, in which I store binary data. dbdirect translates
this column to an attribute of type String:

data Md5 = Md5

instance FieldTag Md5 where fieldName _ = "md5"

md5 :: Attr Md5 String
md5 = mkAttr Md5


When I use mysqldump in order to dump the database contents to a text
file, I get the following:

...
INSERT INTO dateistatus VALUES ('Y4209ACK196222156177136250f140SOi169148',102);
INSERT INTO dateistatus VALUES ('144135X145/217CACK4Y182rJWm169',102);
INSERT INTO dateistatus VALUES ('226m211Z252219&k206194\"anD:129',102);
INSERT INTO dateistatus VALUES ('DC4165192196N203s219161209132NX205DC2255',102);
INSERT INTO dateistatus VALUES ('Ma224IH^,yiEMv139@|n+',102);
INSERT INTO dateistatus VALUES ('169L222DEL215%NR-253171`^a137P',102);
INSERT INTO dateistatus VALUES ('15219918621420!0H/176/216SOHz244',102);
INSERT INTO dateistatus VALUES ('_219RSuETBF135ENQ(\\215DC1DC2141134129',102);
...

Those funny strings are supposed to be MD5 sums in binary form. It seems
like non printing charactes are converted to sequences of digits.

Also, I don't get the original data back when querying the contents.

Bye

--
Volker Wysk <po...@vo...>
http://www.volker-wysk.de