Monthly Archive: November 2011

4

“accessory connected” Regain control of iPod (iPhone) when connected to head unit such as car stereo systems, or third party speakers

The iPhone might consider as the second best iPod, however, it has limitations. For example, you can not delete the songs from the Music app. You can not control the music app if you connect it to the head unit such as the car stereo system, or to some any third party speaker systems; it display a splash with message “Accessory Connect”. Below, some ways you can get around with your iphone with the lastest firmware iOS 5.x.x






0

ORCA MSI Editor

Orca MSI Editor allows you to edit the properties of any MSI file. With this tool, you can change the title and text within the installer an look at how and where the files are delivered.











0

Nỗi Nhớ

Có một ngày nỗi nhớ vây quanh,
Anh biết mình yêu em từ đó
Vần thơ thốt từ trong nõn cỏ
Gió lượn về mang hương tóc em bay….











0

MSSQL: Remove Diacritic Marks From Characters – Vietnamese unicode to non-unicode in database

Sometimes we want to remove accents from vietnamese words to Latin based characters for search or matching routine in database. However, Microsoft SQL Database does not offer normalized function which we can use to remove accents from words such as:

AI ĐI TRÊN DÀM ĐƯỜNG TRƯỜNG => AI DI TREN DAM DUONG TRUONG
ÁO EM CHƯA MÀC MỘT LẦN => AO EM CHUA MAC MOT LAN

Good thing, there is a workaround by using CLR function, please example code below: