How to insert hindi value of json object in SQL Table using java?

Asked Mar 26 '20 at 09:01

Active Mar 26 '20 at 09:31

Viewed 54 times

Am trying to insert the below query,

INSERT INTO form_attributes(FormAttributeTypeID,FormUUID,AttributeValue) VALUES(4,'becb4607-7f43-4b72-aa9e-60b378122716','[{"id":5,"language":"हिन्दी  (Hindi)","renderingOrder":"Left to right","iso":"hi","renderingCode":"LTR","lcid":"hi","flag":true,"default":true}]')

edited Mar 26 '20 at 09:31

Vignesh_A

asked Mar 26 '20 at 09:01

punch

1) are you facing any errors while inserting, can you post errors? 2) can you post the expected output? – Vignesh_A Mar 26 '20 at 09:13
SQL Error [1366] [HY000]: Incorrect string value: '\xE0\xA4\xB9\xE0\xA4\xBF...' for column 'AttributeValue' at row 1 – punch Mar 26 '20 at 11:58
check if this resolves your issue. https://stackoverflow.com/questions/35125933/mysql-utf8mb4-errors-when-saving-emojis – Vignesh_A Mar 26 '20 at 16:52
I already checked this one. But I did not get my solution – punch Mar 26 '20 at 18:10
Can you add the supporting java code and sql scripts? – Vignesh_A Mar 30 '20 at 06:48

How to insert hindi value of json object in SQL Table using java?

0 Answers0