jpegdecompresssurface : picture decode failed : e00002d1

[totoourworld]

jpegdecompresssurface : picture decode failed : e00002d1
I can get exact same data as image data from sql server.
So i try to load image from NSData, below the code,

• (void)process:(NSArray*)results
  {
  NSArray *table=[results objectAtIndex:0];
  NSDictionary *row=[table objectAtIndex:0];
  NSData *image_source=[row objectForKey:@"Company_Logo"];
  UIImage *image=[[UIImage alloc] initWithData:image_source];
  image=[UIImage imageWithData:image_source];
  [self.imageView setImage :image];
  }
  but the final step , it is showing like this, in here
  // [self.imageView setImage :image];
  jpegdecompresssurface : picture decode failed : e00002d1
  How can i solve this?
  Regards.

[martinrybak]

Please try the types branch.

[totoourworld]

I used types branch and used the sample project for testing but same.
can you give me the source code for that?
I checked the
NSData *image_source=[row objectForKey:@"Company_Logo"];
by log the value.
but same as data in sql.
How can i use this for mapping to uiimage type?
can you teach me?
i want your reply. thanks .
king regards,

[martinrybak]

It could be related to this:
https://msdn.microsoft.com/en-us/library/ms177687(v=sql.90).aspx

What version of SQL Server are you using?
What data type is the column with the image?
If possible, can you attach the image file here?

[totoourworld]

I am using the SQL EXPRESS 2016.
I used the Company_Logo(image,null) for saving/loading image.

Additionally, I am trying to load the image that saved by C# program i made.
In android , the image can be read by byte array and convert that to bitmap image, and it is working.
In C# , it is also working well.

but in iOS when i tried to do like that with above code , it is showing
jpegdecompresssurface : picture decode failed : e00002d1

[totoourworld]

[totoourworld]

[totoourworld]

[totoourworld]

[totoourworld]

These three pictures , i used to try.
jpg file looks like that issue , but png file is not showing at all.

[totoourworld]

Hello , Mr.Martin Rybak.
I tried to debug the code and found something related.
So, (void)process:(NSArray*)results
{
NSArray *table=[results objectAtIndex:0];
NSDictionary *row=[table objectAtIndex:0];
NSData *image_source=[row objectForKey:@"Company_Logo"];
UIImage image=[[UIImage alloc] initWithData:image_source];
image=[UIImage imageWithData:image_source];
[self.imageView setImage :image];
}
in this code ,(NSArray) results is returning values from sql.
in here , i checked the @"Company_Logo".
It was NSInlineData and 4096bytes.
That's why the above 5kb jpg image is not showing full.
I tried to use small jpg image (for example 400bytes) , and it is showing well.
Can you give me some solution for large image?
Really thanks for your help.
Regards.

[martinrybak]

Please put a breakpoint on line 544 of SQLClient.m:

https://github.com/martinrybak/SQLClient/blob/types/SQLClient/SQLClient/SQLClient/SQLClient.m#L544

What is the value of column->size?

[totoourworld]

in image type the column size is 4096

[totoourworld]

column->size is 4096