Monthly Archive: June 2013

Jun 21

How can I decode UTF-8 encoded data from a MySQL table with Latin1 character set?

If you have UTF-8 encoded data in a MySQL table that has character set set to Latin1 you can use the following SQL statement to correctly decode it: SELECT CAST(BINARY(value) AS CHAR CHARACTER SET utf8) AS value

Jun 14

How can I remove a virtual directory in the Default Web Site using appcmd.exe?

Use the following command appcmd delete app /"Default Web Site"/VDir where VDir is the name of the virtual directory / application under the Default Web Site.Appcmd.exe can usually be found in the C:\Windows\System32\inetsrv folder.