Re: [Mysql-cocoa-users] Bug with blob in framework or in my code ?

[Eric V. <ev...@cl...>]

The problem is solved (thanks to Hayden Stainsby)

The data must be converted from hexa to NSData

A new function "decodeBinaryData" may be very useful !

--------

- (NSMutableData*)decodeBinaryData:(NSData*)data
{
	int				i, theLength;
	const char		*thumbnailHex;
	char			*buffer;
	NSMutableData	*thumbnailData =3D [[[NSMutableData alloc] init] =
=20
autorelease];

	thumbnailHex =3D [data bytes];
	theLength =3D [data length];
	buffer =3D (char *)calloc(sizeof(char),(theLength/2));
	int index =3D 0;
	for (i =3D 0 ; i < theLength ; i +=3D 2)
	{
		char aByte, tChar[2];
		=09
		tChar[0] =3D thumbnailHex[i];
		tChar[1] =3D thumbnailHex[i+1];
		=09
		tChar[0] -=3D 0x30;
		if (tChar[0] >=3D 0x0a)
		{
			tChar[0] -=3D 0x07;
		}
		=09
		tChar[1] -=3D 0x30;
		if (tChar[1] >=3D 0x0a)
		{
			tChar[1] -=3D 0x07;
		}
		=09
	=09
		aByte =3D tChar[0] << 4;
		aByte =3D aByte | (tChar[1]);
		=09
		buffer[index] =3D aByte;
		index++;
	}
=09
	[thumbnailData appendBytes:buffer length:(theLength/2)];

	return thumbnailData;
}


Le 27 janv. 07 =E0 09:58, Eric VERDIN a =E9crit :

> Hello,
>
> I  try to save and read a picture in mysql.
> I use the standard version (4.1.22 and 5.0.27 of mysql package) with
> the same problem.
>
> ( http://sourceforge.net/mailarchive/forum.php?
> thread_id=3D31463383&forum_id=3D2800 )
>
> When i read the picture in mysql, the size is double !
>
> Do you have the same problem (blob with utf8 ?) ?
>
> Any help would be most appreciated.
> Thank you very much.
>
> Eric
>
>
> ----------------------------------------------------------------------=20=

> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =20
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?=20
> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>