inserting String value of byte array in mysql database

Question

I have a byte array as shown below,

byte b1[] = {-127, -87, -32, -112};

when I'm trying to convert it to a String it's showing black diamond like character, I want to insert it in the database.

Which charset should I use for database?

I have tried utf8mb4 and CP1250? I'm using mysql version 5.7.14 ?

Given below error while inserting:

java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBD\xEF\xBF\xBD...' for column

Here is the code:

   byte b1[] = {-127, -87, -32, -112};
   TRNRequest tr = new TRNRequest();
   tr.set(new String(b1));
   trnRequestService.saveTransactionRequest(tr);

trnRequestService is dao layer service which stores object in database and TRNRequest is my class, I am using Hibernate for database connection. I want to read this character

public class DbByteInsert {
        public static void main(String[] args) {
             System.out.println(new String(new byte[]{ 48, 50}));
             System.out.println(new String(new byte[]{ -127, -87, -32, -112}));
        }
}

check this example I am able to insert first byte array in db but I can not insert second..!

How can anyone guess ur encoding, provide atleast code where from you got this? — Noman Akhtar, Nov 30 '16 at 09:52
How you are converting byte[] to string. Use Arrays.toString(b1) to convert array into string and insert the resulted string into database — Rajashekhar, Nov 30 '16 at 09:55
How are you inserting the data? Where's your code? Why do you let us guess what the real problem is? — f1sh, Nov 30 '16 at 10:08
Getting black diamonds means that the bytes cannot be decoded to a string. *You're losing data when you convert to string.* What are you trying to do? If you want to insert binary data into a database, you can, just don't try to convert to a string. — Joni, Nov 30 '16 at 10:14
Possible duplicate of [Java Convert integer to hex integer](http://stackoverflow.com/questions/9321553/java-convert-integer-to-hex-integer) — AxelH, Nov 30 '16 at 10:15
I have added part of my code, I want to insert String into database, I am receiving this byte array from server which I want to read...! — Shailesh, Nov 30 '16 at 10:16
use Arrays.toString(b1) instead of new String(b1) to convert it into string — Rajashekhar, Nov 30 '16 at 10:37
@Rajashekhar it's giving the same array in string format as [-127, -87, -32, -112] — Shailesh, Nov 30 '16 at 10:46
Ok, add an example of _input -> encode -> output_ This is not clear. From what I can see, you will not store what you want. Forget about the Database for now, your String is incorrect. I see 4byte and a String much longer. — AxelH, Nov 30 '16 at 10:48
When you not pass any charset to string constructor it takes platform default charset. check once by passing charset database is using to string constructor — Rajashekhar, Nov 30 '16 at 10:59
An what is the output of those and the expect result? You are converting a negative byte into a character (basicly) ... — AxelH, Nov 30 '16 at 11:08
{ 48, 50} gives 0 2 and {-127, -87, -32, -112} black diamond like chars — Shailesh, Nov 30 '16 at 11:21

inserting String value of byte array in mysql database

0 Answers0