[Mysql-cocoa-users] Blob ?
Brought to you by:
sergecohen
|
From: Camille Goureau-S. <ca...@lu...> - 2003-05-20 04:36:38
|
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
|