Styjun

Explain Ant-Man's "not it" scene from Avengers: Endgame

Regarding eBGP Multipath

Is it OK to bring delicacies from hometown as tokens of gratitude for an out-of-town interview?

Comma Code - Ch. 4 Automate the Boring Stuff

Humans meet a distant alien species. How do they standardize? - Units of Measure

How bad would a partial hash leak be, realistically?

Initialize an std::array algorithmically at compile time

Movie where a boy is transported into the future by an alien spaceship

What is the history of the check mark / tick mark?

How were concentration and extermination camp guards recruited?

3 as a Sum of 3 Pan Digital Expressions

Count line of code for Javascript project

Java 8: How to convert String to Map<String,List<String>>?

What does War Machine's "Canopy! Canopy!" line mean in "Avengers: Endgame"?

Convert camelCase and PascalCase to Title Case

Responsibility for visa checking

What is the purpose of building foundations?

What are the words for people who cause trouble believing they know better?

Pronoun introduced before its antecedent

What are they doing to this poor rocket?

How to pass a regex when finding a directory path in bash?

What's the correct term for a waitress in the Middle Ages?

Short story written from alien perspective with this line: "It's too bright to look at, so they don't"

How could a possessed body begin to rot and decay while it is still alive?

Remove emoji and hex code from String into order to store into MySQL with utf8

Remove HTML tags from a StringRemoving whitespace from strings in JavaHow to remove the last character from a string?java.sql.SQLException: Incorrect string value: 'xF0x9Fx91xBDxF0x9F…'Store byte array in MySQL from JavaIssue with emojis on a tomcat web applicationJOOQ emoji (utf8mb4) supportJDBC MySQL store emojis without utf8mb4 encodingutf8mb4 in MySQL Workbench and JDBCSave emojis using mysql connector 8 against server 5.6.22

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I got the following error message while my program trying to save some data into MySQL table encoded with utf8_unicode_ci.
java.sql.SQLException: Incorrect string value: 'xF0x9Fx91xA8 m...'

while xF0x9Fx91xA8 seems like hex code of 👨‍👨‍👧‍👦
I wish to remove all of these from the String so I could store them into mysql table without changing encoding of the table.

I have tried the following methods, but no luck
https://www.baeldung.com/java-string-remove-emojis

java

share|improve this question

asked Mar 24 at 13:24

XiaoShun TanXiaoShun Tan

1816

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please, paste the code, you are using and describe error and desired behavior
  
  – Andronicus
  Mar 24 at 13:25
  

  
  
  
  

add a comment | 

0

I got the following error message while my program trying to save some data into MySQL table encoded with utf8_unicode_ci.
java.sql.SQLException: Incorrect string value: 'xF0x9Fx91xA8 m...'

while xF0x9Fx91xA8 seems like hex code of 👨‍👨‍👧‍👦
I wish to remove all of these from the String so I could store them into mysql table without changing encoding of the table.

I have tried the following methods, but no luck
https://www.baeldung.com/java-string-remove-emojis

java

share|improve this question

asked Mar 24 at 13:24

XiaoShun TanXiaoShun Tan

1816

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please, paste the code, you are using and describe error and desired behavior
  
  – Andronicus
  Mar 24 at 13:25
  

  
  
  
  

add a comment | 

I got the following error message while my program trying to save some data into MySQL table encoded with utf8_unicode_ci.
java.sql.SQLException: Incorrect string value: 'xF0x9Fx91xA8 m...'

while xF0x9Fx91xA8 seems like hex code of 👨‍👨‍👧‍👦
I wish to remove all of these from the String so I could store them into mysql table without changing encoding of the table.

I have tried the following methods, but no luck
https://www.baeldung.com/java-string-remove-emojis

java

share|improve this question

asked Mar 24 at 13:24

XiaoShun TanXiaoShun Tan

1816

share|improve this question

asked Mar 24 at 13:24

XiaoShun TanXiaoShun Tan

1816

share|improve this question

asked Mar 24 at 13:24

XiaoShun TanXiaoShun Tan

1816

asked Mar 24 at 13:24

XiaoShun TanXiaoShun Tan

1816

asked Mar 24 at 13:24

XiaoShun TanXiaoShun Tan

1816