[Mysql-cocoa-users] Blob ?

[Camille Goureau-S. <ca...@lu...>]

Hi,

did anybody manage to retrieve a blob ?

with string :  "marotte ange"
             chaine2 = [NSString stringWithFormat: @"insert commentlong 
(texte) values (\"%@\") ;", [cnxCommentaireLong stringValue]] ;

it gives in MySQL :
mysql> select * from commentlong ;
+----+--------------+
| id | texte        |
+----+--------------+
|  1 | marotte ange |
+----+--------------+
1 row in set (0.05 sec)

But when retrieving it it gives :
                 SMySQLResult *result2 = [connectMySQL queryString: 
[NSString stringWithFormat: @"select texte from commentlong where id = 
%@ ;",[ligne objectForKey: @"id_commentlong"]]] ;
                 [cnxCommentaireLong setStringValue: [[result2 
fetchRowAsDictionary] objectForKey: @"texte"]] ;

<6d61726f 74746520 616e6765 >

any idea ?

Thanks.

Camille