Category Archive: Troubleshooting

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

Nov 23

How can I determine which process occupies a port?

To find out which process uses a certain TCP or UDP port you can use a tool called netstat. Netstat is a command-line tool that displays incoming and outgoing network connections, routing tables, and network statistics. So to determine which process is listening on port 80, go to command prompt and type netstat -aon | …

Continue reading »