Saturday, February 25, 2012

BLOB data

I am working on integrating Novell's IDM JDBC driver with a SQL 2005
database to retrieve user photos. The photos are in BLOB format, however
they are too large for eDirectory to handle. Is there a way to resize data
that is already stored in a BLOB field? If not, what's the easiest (and can
be automated easiest) way to export and resize these files? Thanks in
advance!!
Joey
Write a C# app to do it (there are all kinds of image libraries available
out there). SQL Server just sees a big string, basically, that represents
the graphic. There is no way for SQL Server to resize or resample graphics
you store, just like your fridge can't change a 2 L bottle of milk into a
500 mL bottle. :-)
"Joey Kinney" <joey.kinney@.rackspace.com> wrote in message
news:uQM%23dnFlIHA.5160@.TK2MSFTNGP05.phx.gbl...
>I am working on integrating Novell's IDM JDBC driver with a SQL 2005
>database to retrieve user photos. The photos are in BLOB format, however
>they are too large for eDirectory to handle. Is there a way to resize data
>that is already stored in a BLOB field? If not, what's the easiest (and
>can be automated easiest) way to export and resize these files? Thanks in
>advance!!
> Joey

No comments:

Post a Comment