Error writing text into a DB table

Sunil Zacharia

Certified Lead Developer

over 5 years ago

Hi,

I'm getting the below error when writing a text value in the database:

java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8A\x0A\x0A

I guess it is because of the column collation is "utf8_general_ci" and does not support unicode characters. I already tried changing the collation type to unicode but it still does not work.

Did anyone else face similar issue? Please suggest a solution.

TIA

Regards,

Sunil Zacharia

Discussion posts and replies are publicly visible

Parents

0 chandu
A Score Level 2
over 5 years ago

Hi sunil, I come across these type of unicode characters when the Business use to send some smileys . I tried to persist through my sql DB changing the collation type. I did not succeeded. Please try to clean your data before sending it for persistence.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sunil Zacharia
Certified Lead Developer
over 5 years ago in reply to chandu

Hi Chandu,

Can’t clean the data because that would remove other characters as well which would alter the message itself.
For example: a currency character like a dollar or euro symbol behind an amount will be cleaned up. This is not desirable.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandu
A Score Level 2
over 5 years ago in reply to Sunil Zacharia

Will it be possible to share the text that you are trying to insert here?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sunil Zacharia
Certified Lead Developer
over 5 years ago in reply to chandu

I can’t share the exact text as it’s customer data. What I’m trying to process is an email body with Unicode characters. You can try a simple piece of text with a smiley and currency symbols.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sunil Zacharia
Certified Lead Developer
over 5 years ago in reply to chandu

I can’t share the exact text as it’s customer data. What I’m trying to process is an email body with Unicode characters. You can try a simple piece of text with a smiley and currency symbols.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data