How to transfer ownership of your android application


Suppose you have developed an Android game and publish that on the Google play. Many users downloaded your app, and you have released few versions also. What if a company wants to acquire your app game? You need to transfer your app to the new business account, and it should display as their registered app. Google makes it quicker and easier way to transfer the ownership of application from one account to another account.

  1. First you have to login to the Google play publish account using the original app owner’s credentials.
  2. Then click Help & Feedback -> Contact Support
    Google Play: Contact Support
  3. Select “I would like to have my apps transferred to a new account. Once you select that it asks to fill the form to resolve the issue.
    Google Play: Contact Support
    Google Play: App Transfer Form
  4. Follow the provided guidelines. It contains several checklist to make sure you are ready to submit the transfer request
    Google Play: App Transfer Checklist
    Make sure,
    You’ll need to prepare both developer account tosubmit your app transfer.

    Original Account – This is the account where your app is currently published.
    Target Account – This is the account you want to transfer your app to.

    Google Play: App Transfer Checklist
    Google Play: Checklist step

  5. Finally, Fill the “Application Transfer Request” and submit the form. Normally Google responds to your request within a day, and if all the details are correct they transfer the app to new account
    Google Play: App Transfer Final Step
    Google Play: Application Transfer Request Form

Google Play: Submit Success

Emoji and web application


Download SQL query

I am back after few months or so of not blogging. Have you heard something called “Emoji”?

iPad Emoji Keyboard

Emoji; is the Japanese term for the ideograms or smileys used mostly in Japanese electronic messages and webpages. These small images are starting to appear more and more outside Japan. Originally meaning pictograph, the word emoji literally means “picture” (e) + “letter” (moji).

If you want to know what the emoji meanings check the following cheat sheet

Although originally only available in Japan, some emoji character sets have been incorporated into Unicode (Unicode 6.0 in 2010), allowing them to be used elsewhere as well. The core emoji are as of Unicode 6.0 consists of 722 characters.

More recent iOS, Android, Windows 8 and OS X (Mountain Lion +) display Emoji natively, regardless of the typeface. However, how we display that on the all other desktop and the web application? When you are viewing Emoji with unsupported device or browser, Emoji shows up as squares or foreign text. You can convert them to a viewable format just by pasting it in the box above then viewing it in the preview.

I have found that several open source JavaScript libraries and the projects support for this. The most comprehensive seems to be Github’s Gemoji project.

Following are some of other good projects and scripts

For more info about Emoji Unicode table, please check below URL

Emoji and Database

Emojis are UTF-8 encoded symbols. Therefore, to save the Emoji in the database, your database column should support for the UTF-8 encoding.

Emoji and MySQL

To store the Emoji in the MySQL, you have to modify the table character set to support UTF-8.  Please keep in mind starting from iOS5, Emoji represents as 4-byte characters.  That means your MySQL table charset should set as utf8mb4. (Earlier version of iOS Emoji worked well with utf8 charset). utf8mb4 support is dependent on the MySQL version that you use. MySQL 5.5+ works fine with 4-byte characters when properly configured.

create table MyEmoji (emojicolumn VARCHAR(255) CHARACTER SET utf8mb4) default character set utf8mb4;

Make Sure Followings,

  1. Your database table character set is: utf8mb4
  2. Your PHP application character set is: UTF-8
    <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
     header('Content-type: text/html; charset=utf-8');
  3. In the application database, connection character set is: utf8mb4

For more information:

Emoji and MS SQL

SQL Server does not support UTF-8 by default. However, it supports UCS2 to store Unicode characters. (UCS2 is typically UTF-16).  SQL server handles the UTF-8 conversion automatically. However, keep in mind, MS SQL VARCHAR column type does not support for this. Instead of that you have to use NVARCHAR column type. Then you must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server

For more information:

CREATE TABLE [dbo].[MyEmoji](
    [EmojiColumn] [nvarchar](255) NULL
INSERT INTO MyEmoji (EmojiColumn) VALUES (N'EncodedString')

Make sure followings,

  1. Your database table column is: nvarchar
  2. You are sending in Unicode data by adding an N in front of the encoded string

How to enable Emoji keyboard in iOS and Android

iPhone –
Android –

EmoJi for PHP

Mobile Emulators and Simulators


The most useful tools for the mobile web are emulators and simulators. Following link provides the download resources for hundreds of emulators and simulators.

Sample Screen

Click here to download the list of emulators and simulators

for more info: