This is the archive for January 2007. Recent posts can be found at the main blog page.
This is a simple howto to have MySQL talk UTF-8 (the One True Encoding in most cases) to all clients. I’ve read the MySQL manual about character encodings, and in the end it’s pretty simple to get it working:
CHARACTER SET 'UTF8'to each
CREATE TABLEstatement. Example:
CREATE TABLE test (id SERIAL PRIMARY KEY, somefield VARCHAR(4)) CHARACTER SET 'UTF8';. This can be done at the database level as well (when using
CREATE DATABASE), but most of the times this is done for you by an external party (hoster, sysadmins, ...)
That’s all. All data stored in and retrieved from MySQL is now in UTF-8. Make sure existing data is converted to UTF-8 as well before importing. I found the easiest way is to convert a database dump using a text editor (eg.
:set encoding=utf8 in Vim) or a character set conversion utility such as
Much like last year, I grew a bit older today…
I’ve ‘celebrated’ my birthday at the university in an almost all-day meeting, spending the rest of my time writing UI design mockups and doing database design reviews. Yay…
The following is repeatedly coming up on mailing lists and IRC. Hopefully this blog post reaches more people…
Before the Subversion migration you had to use this line in your
~/.jhbuildrc to have JHBuild use your CVS account settings:
repos['gnome.org'] = ':ext:firstname.lastname@example.org:/cvs/gnome'
Now that we have Subversion, you should use this line:
repos['svn.gnome.org'] = "svn+ssh://email@example.com/svn/"
Don’t forget to change your username!
So, am I right in thinking that a full checkout of the Gnome desktop (using JHBuild) will eat a lot more disk space, now that Gnome uses Subversion, which keeps pristine local copies of all files in
.svn directories? This will be a serious issue for me and probably lots of other people…
Wouter Bolsterlee, also known as uws, a postmodern geek living in the Netherlands. Read more about me…
Unless stated otherwise, all material on this site is available under a Creative Commons Share-Alike license.