MySQL Character Encoding Issues

Posted by matason on Monday, 28 September, 2009 - 18:10

These MySQL commands might come in handy when running up against character encoding issues:

mysql> use `your_database`;
Database changed
mysql> show variables like "collation_database";
+--------------------+-----------------+
| Variable_name      | Value           |
+--------------------+-----------------+
| collation_database | utf8_general_ci | 
+--------------------+-----------------+
1 row in set (0.00 sec)
mysql> show variables like "character_set_database";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+

London to Paris Brompton Bike ride for the Meningitis Trust

Posted by matason on Tuesday, 28 July, 2009 - 00:10

Hey, I'm riding my Brompton from London to Paris next month in aid of the Meningitis Trust, I plan to set off three days before Drupalcon Paris 2009 and should arrive in time for the events on Monday.

Training has begun so if you see me wheezing up and whizzing down the hills around Garstang please shout some abuse encouragement!

More information is available at http://menusandblocks.co.uk/le-tour-de-drupal and if you'd like to sponsor me please visit http://www.justgiving.com/le-tour-de-drupal/

PHPNW09 Registration Opens - PHP Conference in Manchester

Posted by matason on Wednesday, 15 July, 2009 - 08:46

I was talking to Jeremy last night and it's looking like this years Manchester based PHP conference is shaping up to be a good one.

The event is taking place at the Manchester Conference Centre on Saturday, 10th October 2009 and registration is now open at http://conference.phpnw.org.uk so grab your ticket!

Vim Tips

Posted by matason on Wednesday, 27 May, 2009 - 23:04

Pull the Word under the Cursor into a Command Line

I'm always forgetting this one...

use CTRL-R CTRL-W to pull the word under the cursor into the Vim command line, useful for searching etc.

DrupalCamp UK Registration Opens

Posted by matason on Wednesday, 20 May, 2009 - 19:08

Yes indeed, registration for DrupalCamp UK is now open, get your tickets for the two day event at http://drupalcampuk.eventbrite.com/

The UK's first DrupalCamp is being held at the BBC on Oxford Road, Manchester on Saturday 13th and Sunday 14th June 2009 and with just over a hundred places available it's sure to sell out fast!

Manchester to Blackpool Christie's Bike Ride 2009

Posted by matason on Wednesday, 20 May, 2009 - 19:02

The Manchester to Blackpool Christie's bike ride is taking place on Sunday 12th July, for more information visit http://www.christies.org/events/cycling/bikeride/default.aspx