How to modify string value in Insert statement using java

Question

I have insert query like below

INSERT INTO PUBLIC.STAFF(NAME, PICTURE,EMAIL) VALUES
('samplePic', X'89504e470d0a1a0a0000000d4', '[email protected]');

How to modify above Picture attribute string value (X'89504e47 to \x89504e47) and final Query is will be like.

 INSERT INTO PUBLIC.STAFF(NAME, PICTURE,EMAIL) VALUES
    ('samplePic', '\x89504e470d0a1a0a0000000d4', '[email protected]');

Possible duplicate of stackoverflow.com/questions/1144783/… — Anoop LL
– Anoop LL, Commented Feb 22, 2016 at 6:36

Abdelhak · Accepted Answer · 2016-02-22 06:36:18Z

0

Try to use replace method like this:

 String query = "INSERT INTO PUBLIC.STAFF(NAME, PICTURE,EMAIL) VALUES('samplePic', X'89504e470d0a1a0a0000000d4', '[email protected]')";
 query = query.replace("X'89504e47", "'\\x89504e47");

Output:

 INSERT INTO PUBLIC.STAFF(NAME, PICTURE,EMAIL) VALUES('samplePic', '\x89504e470d0a1a0a0000000d4', '[email protected]')

answered Feb 22, 2016 at 6:36

Abdelhak

8,4154 gold badges25 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Madhava Over a year ago

But we have to use regular expression for getting exact binary string match

ManthanB · Accepted Answer · 2016-02-22 06:37:20Z

-4

you should write as below.

UPDATE PUBLIC.STAFF SET PICTURE ='x89504e47' where NAME ='samplePic';

answered Feb 22, 2016 at 6:37

ManthanB

4243 gold badges5 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to modify string value in Insert statement using java

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related