android - picture isn't saved properly into the database (as BLOB) -

-

I try to save a photo as a blob in the database, but it is not properly stored in the database .

Byte [] that is passed is correct and has 4300 characters and the database contains only 12 characters, this is what is stored in DB: [B @ 43E7B 068] < / P>

Here is the code for my SQLandSERT: 

  Public Bullion SQL_INSERT_PICTURE (PictureDype Type) {try.d = OpenHelper.getWritableDatabase (); Log D. (Tag, "insert picture"); System.out.println ("Insert Image"); Db.execSQL ("Remove from the picture" + "where" + LinkPic + "= '" + type.getLink () + "'"); "+" Value ('+' type.getName () + "',' ',' ','" + Type.getLink () + "','" + type.getPicture () + "')"); System.out.println ("Picture size (BitairAir):" Type. Zant Picture (Length);); System.out.println ("Picture:" + type.getPicture ()); System.out.println ("Insert"); db.close (); return true;} hold (escalationation) {System.out.println ("insert failed"); db.close (); description is false;}}   
 My question is why is not the right byte [] stored in DB or how can I do it? If you need more information or code then  
 thx kirbby   
 
 
 Use this code to convert to a byte array which can be stored as a BLOB for:  
  private byte [] getBitmapAsByteArray (bitmap bitmap) {Baitareonputstrym output stream = new Baitareon output stream (); // mid-priced quality , But PNG is flawless, so it has been ignored. Bitmap.compress (CompressFormat.PNG, 0, OutputStream); Return Output STream.toByteArray (); }   
 OR <<> private byte [] getBitmapAsByteArray (bitmap bitmap) {final full width = bitmap.getWidth (); Last int height = bitmap.gatehit (); ByteBuffer byteBuffer = BitFufer.Olock (width * height * 4); Bitmap.copyPixelsToBuffer (ByteBuffer); Return byteBuffer.array (); }   
 The first option should always work. The second option is 32bits-per-pixel (ARGB_8888 format) thus follows 4 bytes. If you have a bitmap of another format (like 565), then he needs some modifications.  
 When you read image data from the database, do so:    public bitmap loaded icon (long ICID) read {// database. ... byte [] = Bitmapdeta Karsrkgetblob (Karsrkgetindaks (Colmkiskanskdeta)); Return Bitmapficht. Decodbatearere (bitmapdata, 0, bitmapdata.line); }   
 Make sure the database to your "table" is defined as the time BLOB execute SQL statements.

Comments

Post a Comment

Popular posts from this blog

qt - switch/case statement in C++ with a QString type -

-
I want to use switch-case in my program but the compiler generates an error. How can I use the switch statement with QString ? The compiler gives me this error: The expression of the switch type 'QString' is invalid My code is as follows : boolStopWord (the word QString) {bool flag = false; Switch (word) {case "the": flag = true; break ; "On" case: flag = true; break ; Case "in": flag = true; break ; Case "your": flag = true; break ; Case "near": flag = true; break ; Case "all": flag = true; break ; Case "this": flag = true; break ; } Return flag; } How do I use the switch statement with a Caststring ? You can not use the switch statement in C ++ language with integral or enum types. You can formally enter the square type of object in the switch statement, but this means that the compiler will look for a user-defined conversion to convert it to an integral or enum type.
Read more

python - sqlite3.OperationalError: near "REFERENCES": syntax error - foreign key creating -

-
I'm trying to create a predefined key after checking the manual and I wrote it: Db.execute ("create table" Table 2 (id, integer primary key, somedata integer) "db.execute" (table creation table 2 does not exist (name text, maintain reference (id) ") and found this: sqlite 3. Operation error: near" references ": syntax error Your second ligne is wrong db.execute ("create table if table does not exist 2 (name text, my_id integer, foreign key (my_id) reference Maintenance (ID)) ") as explained
Read more

Python's equivalent for Ruby's define_method? -

-
What is a Python equivalent for Ruby's define_method , which is the dynamic generation of class methods will allow? (As can be seen in Wikipedia) Functions are first-class objects in Python and assign them The properties of a class or an example can be a way of doing the same thing as a Wikipedia example: colors = {"black": "000", "red": "F00", "green": "0f0", "yellow": "ff0", "blue": "00f", "magenta": "fff", "cyan": "0ff", "white": " FFF "} Class MyStream (ARR): Pass for Name, Code in colors.iteritems (): def _in_colour ( W code = code): return '& lt; Span style = "color:% s" & gt;% s & lt; / Span & gt; ' % (Code, self) setter (histrive, "in_" + name, _in_ color)
Read more