dare to dream is Moving to its own server!

This blog is moving to its own server. However, it will be still on wordpress platform. The new address is protishobdo The word ‘protishobdo’, which is originated from Bengali language means reflection of sound! Special thanks to Kowser vai, for this name. I will be updating regularly my blog here with awesome topics, tricks and tips. I have already migrated all the post and comments to new server. Feel free to ask any question, ask for any topics that you want as a blog post. See you all at my new address.

Facebook Like, a simple wordpress plugin!

This plugin shows a facebook like button on your wordpress blog in your index page and posts. Just install the plugin, activate it from your admin and you are done. The facebook like button will show up in your main page with every post and in all individual posts page as well. This plugin is still on development, so any feedback would be highly appreciated.

Installation:
1. Download the zip file.
2. extract it
3. upload it to your blog’s plugin folder.The path should be wp-content/plugins/
4. Go to your blog Admin Page
5. activate the plugin ‘Facebook Like’

and you are done!

Social Media, 140 characters of life!

Waking up in the morning to read the newspaper, listen to hourly radio or television news, nah the time is up for that. No more printed newspaper, no more TV and radio for news. No more going out to gossip with friends, no more socialising by going relatives home, no more seminar to learn about technology!

Social media, one kind of media to make people more social, no? well, in my opinion it is. Lets discuss and learn what we have right now and what we should know about them. What if you ask me to tell about myself I will give you my website address where you will find several social media sites link to know about me. Is it unsocial? I don’t think so, because there you will find more about me what probably, I can’t express to you face to face.

Twitter, Facebook, Ning, Tagged, Vkontakte, Hi5, and so on are some online social media sites that lets you connect with your mates, colleagues, friends, families, relatives and beloved. How much do we know about them?Do we use them? Should we use them? What are the benefits? A lots of questions will rise. In short, you should know some of them to keep pace with the technology, new culture and trend.

Twitter: A micro blogging site where you will be able to update your status, share some knowledge and links within 140 characters. 140 characters are enough to express the emotion or something isn’t it? well, for the limitation in twitter normally people use the shorter version of word spelling. Something that will get you helpful while using twitter:

• Hashtag:hashtag ‘#’ is used before a wrod. It is being used to specify a group who have same interest with the hashtaged word. So some examples of hashtag words are #fail, #iesucks, #iwantthis and so on!
• List:Its a module where a user can create a list and can include twitter-er whoever they want.
• Mention:To mention somebody, anyone can use ‘@’ sign before their twitter user name.
• Re-tweet:Now a days twitter added a new function where one can easily re-tweet others tweet by clicking retweet what appears under every tweet. Another way of re-tweeting is adding ‘RT’ and mentioning the user.
• Direct Message:There is another option to message a user directly by going direct messaging page of twitter. Other way of Direct messaging is adding ‘DM’ and mention a user.

Twenty Ten, celebration, Abroad Life and Me !

It was last year when I last updated my blog . It’s twenty ten(2010), a brand new year with lots of hope, inspiration for my walking in the clouds, a year where I need to finish some of my unfinished business, need to prepare for the happiest moment of my life, a year what will give me the chance to prove myself and a lots of other opportunities. I am also prepared for obstacles that I will have to face in this year.

It was a nice NYE I had passed here out of my country. I am thankful to Tan Jek Hui, one of my bosses, for inviting me at the NYE party with them. It was fun and interesting. I attended the wedding party of Ser Young(one of my colleagues) at 2nd January of twenty ten.  I am attending the university for this semester and applied for my visa. Those are all of important topics for last 1 and half months. Ohh I changed my house as well .

2009 was not that bad for me. I attended the university again, completed a semester, got a job in a promising digital agency, built my programming knowledge, worked with some geeks, created some websites, formed a group of promising young boys called polluxLab, started tweettering, become social media addict, gather some inspiration for my life, hell that’s  a lot. I have achieved so many things in the last year

There were something bad happened to me last year as well. However, it was not that scary. I have lost my laptops, need to pay a lots of  money to university. the most bad happened to me was I was physically broken, probably mentally as well in a specific point. I will try my best to be more perfect and will try to avoid any mistake in this year.

Wishlist for this year:

1. Become a ZCE
2. Become pro in Java
3. Research and Development some ideas
4. Regular Blogger
5. Be with my Beloved
6. Solve some personal problems
7. Find the way of becoming happy!

Happy New year

MySQL search query, collation and case sensitivity.

I was working on mysql database and was creating a search system module for a big mysql database. Everything was going fine as usual, query was working, no bugs, database was responding. However, the main problem that I notice was case sensitivity search. My searching query was case sensitive. Although I used LIKE ‘serachquery%’ in my code but the case sensitive search cannot be prevented. If you are having this problems then there are some solutions.

The first thing is you need to know about the database collation. What is collation? shortly ‘A collation is a set of rules for comparing characters in a character set’. If you want to know briefly about collation then you should look at mysql documentation about collation, encoding and character set.

There are three type of case sensitiveness in mysql database collation.

• ‘_bi’ -> This means binary case sensitive
• ‘_cs’-> This means case sensitive
• ‘_ci’ -> This means case insensitive

Solutions:

1. First, look at your database and see what type of collation did you assigned for your table entity?? If it is binary case sensitive AKA ‘_bin’ or case sensitive AKA ‘_cs’ then your normal LIKE ‘searchquery%’ won’t work. So the first way is if it possible to change the collation type.

2. The second way is much easier and code related. the code can be something like this.

SELECT tableEntity FROM table_name WHERE UPPER(tableEntity) LIKE UPPER('search_query%');

The logic for this query is whatever search query is, we are making the query in upper case using UPPER() function of mysql and we are making the result of our tableEntity in uppercase as well.

Hope those solutions will help you. Happy coding!