I have a few questions about how .net provider handles blobs. In a couple of different projects I've tried using blob fields to manage data, one was for an SMTP server where I was keeping the body of the messages in the blob, but it kept giving me illegal character errors, I tried escaping the apostrophes with double apostrophes and still no luck, I ended up temporarily fixing the problem by handling it as a varchar at max possible length but that is too small... 37Kb from what I undstand, I would also like to handle attachments, and now for a different project I need to have pictures of the employees and members of an organization in the DB so I'm trying to convert JPEGs to blobs but I have the same problem as with the email bodies, in C# I'm handling the file contents as a string, has anybody done something similar, or at least have any suggestions as to whether is possible or not??
James ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider