Month: March 2011

Open Source
Programming
SQL
Tips and Tricks

Select Case Sensitive in MySQL

Today I found bug on my website while using MySQL query. I just realized that the search function works in case insensitive. If I execute this query: SELECT filename FROM data_ebook WHERE filename = ‘Manasik_Haji_dan_Umroh.pdf’ the results will be: — Manasik_Haji_dan_Umroh.pdf Manasik_Haji_Dan_Umroh.pdf — By using keyword ‘LIKE BINARY’ it can make the result case sensitive: […]

Read More
Internet
Tips and Tricks
Tutorial

How to Migrate from WordPress to Blogspot

This is step by step how to migrate from WordPress to Blogspot: 1. Login to WordPress and go to Dashboard => Tools => Export => press Download Export File button. 2. Go to http://wordpress2blogger.appspot.com/ and submit the .xml file exported from WordPress, then you will have another .xml file downloaded. 3. Login to Blogspot and […]

Read More
Mac
Tutorial
Windows

Dual Boot Mac OSX and Windows 7

Prepare at least 3 partitions: – Partition 1, 80GB, for Windows 7 – Partition 2, 80GB, for Mac OSX – Partition 3, the rest, for Data 1. Install Windows 7 on partition 1 2. Install Mac OSX on partition 2 For Mac OSX, I was using AsereBLN boot loader. To switch between Mac OSX and […]

Read More
Mac
Tips and Tricks
Tutorial

Read / Write NTFS on Mac OSX

Open Disk Utility: Applications => Utilities => Disk Utility Right click partition, and click Information. Take note the value on Universal Unique Identifier. Open Terminal: Applications => Utilities => Terminal Edit /etc/fstab: $ sudo nano /etc/fstab Type in this line into /etc/fstab: UUID=[type in UUID from disk utility] none ntfs rw Save the file. Reboot.

Read More