Where do you get this error ? You run some custom query in SQL ?
IMHO - The problem is you want to distinct a blob. You have to make it varchar at first (CAST(field AS VARCHAR(4000)) ....
I hope I worte it correctly and I hope that is what you need