How can I read the contents of the image data from the sql server database

advertisements

I have a ArcSDE SQL server database. according to arcSDE schema CodedValues for domains in geodatabase stored in GDB_CODEDDOMAINS table in IMAGE format. how can I convert this image data type of coded values to string that can be human understandable. In other word I want to convert this data type to string and extract each code value of domain in separate string variable. please give me idea to do this work.

If the question is unclear pleas tell me to explain more!


The contents of an IMAGE type column come back to C# as a byte[]. You can basically do anything with it. My first guess would be to try to convert it to a string using

string content = Encoding.UTF8.GetString(buffer);