Archive for May, 2008

Viewing Flickr as a solar system

Flickr is possibly the largest collection of public photos on the planet.  Flickr has an API which allows anyone with some programming skills to write their own programs and websites, etc using their images and data. Yesterday I came across the http://taggalaxy.de/ which allows you to view Flickr as a solar system.  You search for […]

Creating a MySQL unicode UTF-8 database

Here’s the syntax for creating a UTF-8 database in MySQL as I can never remember it! 1CREATE DATABASE `databasename` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;