Emoji is using 4 byte Unicode. MySQL 5.5 support 4 byte character. You need to change

• Make sure all your tables' default character sets and text fields are converted to utf8mb4 ( eg. ALTER TABLE mytable charset=utf8mb4 )
  
• Before Insert or SELECT query , need SET NAMES utf8mb4 first.

ref: http://stackoverflow.com/questions/7814293/how-to-insert-utf-8-mb4-characteremoji-in-ios5-in-mysql

Taken at Marina Bay Singapore

I got a problem

when

I didn't know why the error occur. After spending a minute and found the answer in stackoverflow.

and then update the submodule again. It's working fine.

Yesterday , my wife app has approved in marketplace. So , I login to the AppHub at last night. I saw she used wrong keywords and marketplace app icon is wrong. So, I click on edit meta description. My hell is starting...

My Firefox is reloading over and over again at edit meta description page. After the it hanged. I can't do anything. I restart the browser and I used Internet explorer.

Oh! God!! App didn't publish and it change to the stage 2. I need to fill data and upload all information again. And then wait for certificate again. I can't believe it.

I click on the app name. Inter explorer didn't show. It look like no connection. So, I clean the browsing data and refresh again.

It worked . I added information and next. Go offline again. WTF !! I did cleaning browsing again. Same problem . I gave up for now. I will try again tomorrow.

I can't believe . Why AppHub website is really stupid. Microsoft may need to update silver light or what ? Why appub silver light is only working on IE and have a problem with firefox
? Why IE show always offline in AppHub website. That is really really annoy for developers. If Microsoft didn't fix that problem, most of the developers will run always because of AppHub.

I told my wife, why write windows phone 7 app. Change to android or iPhone. AppHub can't bet android or iPhone. They need to fix a lot in website.

I ask wp 7 development problem in Stackoverflow and nobody reply. Not like android or iPhone dev. It mean , not so much developer. So, that why not so much app in marketplace. I gave up marketplace when I first use. Very hard to use for me.

Hmm... Let try tonight again and see the result

I bought Nokia Lumia 800 for my wife. She want to develop apps , so she bought the AppHub developer account for 1 year. After that , I saw Nokia gave $25 for Nokia Lumia user. That is cool! So, I told her and let buy a game.

 

Trouble time is starting

 

When I go to the marketplace on phone and try to buy it. There is no Credit card and I need to add a credit card. OK, I add it. But I can't.

The card already exist and can't add. So, I try to add from Zune.net and I found my card already add in zune.net. It look like she bought AppHub and it already connect with Zune Account. I try remove and can't. I can't check my subscription also. Subscription is not available for Singapore.

She can't buy it. So, go to zune support and chat no reply.

 

Try to login from Zune Application on Windows. Can't login from Singapore.

Try to login Xbox Live Account to check the card. Website show error.

 

So, the result is we can't buy app from marketplace. Zune App store , it's useless from Singapore. I waste two days and I can't buy yet.

 

I tested nide IDE in last week. It's look cool but it's not useful for me. I prefer Sublime Text 2 instead. Nide IDE is really for node.js but it's running on webbase. Currently I have some project and I can't edit with nide and it crash. I don't like the web IDE like cloud9 because I feel it's slower than Application. I prefer to change syntax color in texteditor. I prefer to change font style. Web IDE is very limited for development. It's cool but still not awesome.

Nide is same like that. I am happy when I saw Nide. I tested with empty project and it look cool. So, I tested in current project and it crash sometime and app is stop. However, nide is a opensource. I wanted to create the web IDE like nide before. But I don't have a enough time. When I saw Nide IDE , I said "Woww!! we have a same dream". You can learn a lot  from nide and you can try to imporve nide IDE. That is really cool.

I went to the queue at clementi mall stathub at 9 am today. My turn arrived at 11:45 and I really hoped I would get iPhone 4S. However, starhub was asking about my bank billing. I don't understand why they are asking me about bank billing ? They told, they need to confirm address. That is stupid answer. Bill address may change. I don't buy any house at Singapore yet. So, I may change my house. Why they need to confirm. I queue so long time and it's nothing. I told the starhub , "I will go back and take my bank billing. Should I need to queue again ?" , He told yes and calling to another one. WTF!! I didn't finish yet. It look like they don't want to sell to me. I went back home and took a billing paper and wait the queue again. After 2 hours my turn will arrive soon. However, some of the people were asking about stock. They have no more stock and only 64 gb available . But they didn't declare it. If he didn't ask or I didn't ask , I couldn't know. Starhub don't care about the queue and customer. So, I went to the Jurong Point starhub. Same. Didn't care about the customer. After 10 minute , they show out of stock. I went to the IMM and no more starhub again. I don't want to buy from starhub. First time , I feel , they are careless. They don't care I buy or not. So, I choose the M1.

When I arrive M1 at 2 pm, it already have a long queue. When I started the queue , two M1 girls gave me the queue number and some form. It mean, I am sure to get iPhone 4S today. Not like starhub. M1 list all the stock and gave a paper for queue. They can check easily stock available or not. After 2 hour queue, I got the another queue number. But this time no need to queue again. I went around IMM and having dinner at IMM also. 9 pm , my queue number is showing and I just took my iphone 4s. Yes, I waste 12 hour ( 9am to 9 pm ) for iphone 4s. When I use iphone 4s, Siri don't understand my pronunciation. Some pronunciation can understand in UK and some can understand in US. So, I can't use Siri but I can study English pronunciation with Siri. Finally , I got iPhone 4s in today. It cost is not only money but also including the times.