English 中文(简体)
• 如何将图像储存在电传数据库中[复制]
原标题:How to store images in the sqlite database in iphone [duplicate]
This question already has answers here:
Closed 11 years ago.

Possible Duplicate:
Reading and writing images to an SQLite DB for iPhone use

How to store a images file in database in blob type in sqlite database and how to retrieve a image from the database.

最佳回答

a. 保存贵方文件目录中的图像。 在数据库中,这一形象的路由来。 这是一个好的做法。 如果在数据基数据库中节省篮子,就会如此沉重。 装货需要时间。

问题回答

First convert image into NSData
Then NSData into bytes
Then store that bytes... Sorry I don t know the method that should be called, because I use core data which is far better than sqlite c api

最容易的方法是使用目标C sqlite包裹,例如fmdb。 然后,你可以把NSData从UIImagePNGRepresentation(UIImagePNGRepresentation)转成一个lob子。

或者,你可以这样做:

NSData *rawImage = UIImagePNGRepresentation(myUIImage);
sqlite3_bind_blob(mySavedSQLStatement, 2, [rawImage bytes], [rawImage length], SQLITE_TRANSIENT);




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签