Solved

Saving Tweets with emojis using Twitter4J in a Mysql table

Posted on 2016-10-05
2
93 Views
Last Modified: 2016-10-05
I have a Java application which uses Twitter4J to grab some Tweets and store them in a MySQL database.

When I output tweets to the console when running the Java application, they appear as strange characters which I am guessing is correct, just the console doesn't know how to render them. However when they're saved to the database the characters are saved as ????.

The database field is set to UTF8_bin.

I'm wondering how I can save the tweets and the emojis correctly in the mysql database?

To provide a little more information, this is for a web service which provides the tweets to a mobile application, which will be responsible for rendering the tweets.
0
Comment
Question by:SheppardDigital
  • 2
2 Comments
 

Accepted Solution

by:
SheppardDigital earned 0 total points
ID: 41829880
0
 

Author Closing Comment

by:SheppardDigital
ID: 41829882
Resolved myself
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
A great marketing strategy is diverse.  Read about the not so popular, yet effective, marketing tactics you can start using today!
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question