<div>
<div class="content wysiwyg-content">
I have a Java application which uses Twitter4J to grab some Tweets and store them in a MySQL database. <br />
<br />
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 ????.<br />
<br />
The database field is set to UTF8_bin.<br />
<br />
I'm wondering how I can save the tweets and the emojis correctly in the mysql database?<br />
<br />
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.
</div>
</div>


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.

Saving Tweets with emojis using Twitter4J in a Mysql table

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&#39;t know how to render them. However when they&#39;re saved to the database the characters are saved as ????.

The database field is set to UTF8_bin.

I&#39;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.

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Twitter is an online social networking service that enables users to send and read short 140-character messages called "tweets". Users can group posts together by topic or type by use of hashtags – words or phrases prefixed with a "#" sign. Similarly, the "@" sign followed by a username is used for mentioning or replying to other users. Users access Twitter through the website interface, SMS, or mobile device app. The Twitter Web interface uses the Ruby on Rails framework. The service's application programming interface (API) allows other web services and applications to integrate with Twitter.

Twitter

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.