Archæology

The assorted finds of Artefact Publishing

Weekend plans

The weather is lovely: sunny, fairly still, warm. Perfect for listening to the cricket, sitting in the sun, and the like. The reality: submitting bug reports about a package that was working when I last used it a couple of months ago, but on upgrade is broken (I’m demonstrating it on Monday), and contemplating switching Archæology to use PostgreSQL as the database.

Surely, you might ask, the latter is hardly pressing? Perhaps, except that one recent comment which has non-ASCII characters in UTF-8 comes out as gibberish. Not surprising, since the version of MySQL I have installed is so old that it doesn’t recognise that encoding. So I can either stop using UTF-8 or I can use PostgreSQL.

The second option is of course the preferable one, but is not without its problems. By using MySQL IDs in the URLs of my entries, portability is made difficult, even when there is only one blog in the database (there are gaps in the sequence). Oh well, at least I can listen to the cricket.

Posted by jamie on January 10, 2004 14:46+13:00

Comments

How about that cricket!!

Posted by: sue on January 10, 2004 21:50+13:00

Hi Jamie,
except that one recent comment which has non-ASCII characters in UTF-8 comes out as gibberish.

Perhaps more to do with "posting after preview". If one does a preview, and goes back to the previous page to post, the problem does not display itself.

आलोक

Posted by: आलोक कुमार on January 11, 2004 20:26+13:00