InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 07:45:48 GMT20http://www.sqlservercentral.com/Forums/Topic1399361-1550-1.aspxThanks OPCThu, 31 Jan 2013 04:12:47 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1399361-1550-1.aspxNot unless you can deserialize the object using a SQLCLR object to review its properties, which I highly doubt. There is no native Java capability in SQL Server that would allow you to inspect that BLOB inside the database as if it were an object again, that I know of. You might be able to shoehorn the instantiation of a Java object into the scope of a SQLCLR object somehow by making an external call. Maybe you could have a SQLCLR object pass the BLOB to an external web service or executable for deserialization and inspection, but that would be terribly slow I would venture, if its even technically feasible. What you might want to start doing is storing the parent-child indicators in a separate column(s) next to the BLOB but you still have the problem of inspecting the existing data to initialize the new column(s).Fri, 21 Dec 2012 06:40:49 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1399361-1550-1.aspxHi Experts,Is it possible to convert a java object which is now stored as a BLOB field to character values. The java object in BLOB contains parent and child values ,we need to differentiate those.The blob value contains some numbers, some charcters, some object itself this level of child objects may be more than 4-5 levelIs it possible and if yes then how?Thanks in Advance.Fri, 21 Dec 2012 06:04:06 GMTRatheesh.K.Nair